PDA

View Full Version : Macros not showing?



aysherryan
09-03-2018, 06:00 AM
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?

Logit
09-07-2018, 06:07 PM
.
The macros in your workbook must be designated as PRIVATE.

Go into the VBE and click on one of the MODULES or SHEETS on the left side.

To get to the VBE, click on DEVELOPER / VISUAL BASIC.

p45cal
09-11-2018, 08:29 AM
…they could also carry arguments, or be user defined functions with arguments.