Macro not showing in Excel spreadsheet
 

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?

Macro not showing in Excel spreadsheet
 

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.

--
Regards,
Tom Ogilvy

"Laura G" wrote in message
...
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?