Hello,

Is there an option in Excel 2000 to not display the macro list when users
click on Tools/Macros? Thanks

I do not know a a switch to hide all macros, but you can remove individual
macros from the list by adding the key word "Private" before the word Sub.
--
HTH...

Jim Thomlinson


"Cam" wrote:

Hello,

Is there an option in Excel 2000 to not display the macro list when users
click on Tools/Macros? Thanks

Hi

You can put
Option Private Module
on top of the module. You can declare it private

Private Sub Test()
'
End Sub

Also, macros with variables passed tothem will not be listed:

Sub Test(Optional B As Boolean)
'
End Sub

HTH. Best wishes Harald

"Cam" skrev i melding
...
Hello,

Is there an option in Excel 2000 to not display the macro list when users
click on Tools/Macros? Thanks