View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Hide Macros from Users using workbook!

Either

make them Private
make them Functions (they will be visible from the function wizard)
make them public but pass a parameter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gr8guy" wrote in message
...
Hi,

Is it possible to hide macros from a user so that they are not visible in
Tools Macro Macros & so that user may not run them by mistake?


Rgds,

Eijaz