Hi,

You can't. But you can implement certain techniques to make the workbook
pretty useless unless they are enabled. This can still be defeated but it's
better than nothing. have a look at the sites below.

http://www.j-walk.com/SS/excel/tips/tip100.htm

http://www.cpearson.com/excel/EnableMacros.aspx

Mike

"Mr. Burton" wrote:

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