how to prevent macros in Personal.xls appearing in other workbook

F

felixthecat

I have some macros in Personal.xls folder which pertain to a certain
workbook, but which appear on the macro list in another workbook. How do I
prevent these macros showing up in non relevant workbooks?
 
L

Luke M

If your macro only pertains to a certian workbook, perhaps you should store
the macro in that workbook's VBA, as opposed to your personal.xls? Changes
made to the personal.xls are meant to be applied to all workbooks you work on.
 
T

Trevor Williams

....or if that's not an option then add this line at the top of your module

Option Private Module

It will stop ALL the mactos in the module being displayed in the Macros list.

HTH - Trevor Williams
 
F

felixthecat

Thanks Trevor, but I'd like to keep easy access to the macros while in the
"development stage of the application.
KInd regards, Felix...
 
Top