View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr. Burton Mr. Burton is offline
external usenet poster
 
Posts: 14
Default Do not load if you dont enable macros

Hi, I have a marco I found from this discussion group, its about locking cells.
I need to lock the cells so they dont get tampered with.

My problem is every time the document is opened you have to enable the macro
to run. This is obviously not very helpful as they can just click no and
delete what they want.

My question is: Is there a way to NOT load the document if the macro is not
enabled? (i.e nothing appears if you do not click enable macros)

That way everything is safe.

Thanks