View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default Not to display Macro list

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