View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Robnific[_2_] Robnific[_2_] is offline
external usenet poster
 
Posts: 2
Default Protecting a macro

You might make the Extra Macro option HIDE
and turn off ALT-F11
Download add-in James 2007 from www.allocator.nl
and check Maintenance option Macro.

"DannyS" wrote:

I am going to distribute a spreadsheet that contains some macros. Is it
possible to prevent users from being able to access the code in the macros?

Ie. stop them going Tools | Macros | Edit?

Thanks!