Ben,
Declare the macro as Public, but include an optional and unused
argument.
Public Sub MacroName(Optional Dummy As Integer)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"ben" wrote in message
...
This is probably someting painfully simple. But I have a
workbook full of
macros, that I don't want the user to be able to access
directly through the
macros dialog box. I know I can keep them out of there by using
Private Sub
declaration, but I want to be able to call them from other
procedures within
the VBA code. Is there a way to call a Private Sub, or is there
a way to make
a sub inaccesible directly to the user but otherwise allowing
VBA code to
access it?
Thanks,
Ben