Prev: conditional formatting = or > cell reference + 2
Next: cell selection troubleshooting
From: Jeremy on 19 Apr 2010 14:47
I have macros to automate on a sheet and want to disable the option to run a
macro under the tool selection on the menu bar. How would I do this?


Thank you


From: Jim Thomlinson on 19 Apr 2010 15:40
Change the macro's declaration from public to private. If you want to hide
all of the procedures in a specific module then use
Option Private Module
at the top of the code module.
--
HTH...

Jim Thomlinson


"Jeremy" wrote:

> I have macros to automate on a sheet and want to disable the option to run a
> macro under the tool selection on the menu bar. How would I do this?
>
>
> Thank you
>
>
 | 
Pages: 1
Prev: conditional formatting = or > cell reference + 2
Next: cell selection troubleshooting