MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to stop user disabling Macro's on start up?

Posted by Paul on January 12, 2001 10:55 PM

Please help have the Auto_Open macro but if the user, cancels running macro's the Auto-Open stops working also.

So can not protect the workbook. ie. Disable the TOOLS menu.

Will a Macro 4.0 Macro do the job??

Please help!

Thanks Paul

Posted by Jim on January 15, 2001 8:02 PM

Any answer on this? I am having a similar problem, but the code is written so that all sheets are hidden on opening and user cannot get to menu because Sheet 1 opens maximized.
Please let me know if there is another solution to stopping the user from disabling the Event macros on Open. Thank you. Jim

Posted by Paul on January 16, 2001 3:08 AM

Yep I will post the code / how to do it. Once I find out but I am at a loss.

Am waiting for the excelent help, that I have found on Message Board before.

Regards Paul

Posted by Larry on January 26, 2001 8:12 AM

I've got the same problem. Is there an answer? -- Larry