Macro not showing in Excel spreadsheet

L

Laura G

I have received a spreadsheet from someone else that
contains a macro. When I open the spreadsheet, I get the
macro warning but when I go into Tools/Macro/Macro, i do
not see it in the list. Is there something else the user
who sent it to me needs to do?
 
T

Tom Ogilvy

If the macro is marked as

Private Sub

or if the module is marked as private,

the macro will not appear in Tools/Macro/Macros.


Also, you can get a macro warning and not have any macros in the workbook.
 
Top