Questions and Answers on Excel Macros
Level: Intermediate
Topic: Macros not showing?
Question:
I get a macro warning in my workbook but when I go to Tools> Macro> Macros (Excel prior to 2007) or Developer/Macros (Excel 2007 and on), I see no macros listed. Is there another place to look?
Answer:
Some developers do not want to make some of their administrative macros available in the "Macro" dialog window. To do so they add "Option Private Module" at the top of a module code window. They may call this module modAdm (for example). If the whole project is protected with a password (lesson 10) then these macros can only be used by someone who knows the password.
To learn more on security see lesson 10 of my Downloadable Tutorial on Excel Macros
To send your questions or comments click here
Back to Q&A on Excel Macros
|