Macro not showing in Excel spreadsheet

  • Thread starter Thread starter Laura G
  • Start date Start date
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?
 
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.
 
Back
Top