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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro works but also runs original spreadsheet 5
When something in module is shown as a macro 3
Digitally Signed Macros in Personal.XLS 3
Log to a file everytime I open a spreadsheet 1
including macro in protected worksheet 2
Moving Macros to the Application Level 2
Macro to generate powerpoint slides 43
Running a macro from the spreadsheet 4

Back
Top