Close if macros disabled

[Thanatos]

Hoping this is an easy one, but i did a bit of a search and couldn't find a solution.

Is it possible to force an excel file to close if someone disables macros?

I have a file that runs a macro on open that will only display sheet tabs assigned to a specific person. However if they disable macros they can see everything... i figure easiest way to stop them is when they click "disable" it pops up saying workbook must run macros and will now close.


Does that sound feasible, or will the macro making it do that not run when they disable it?


Cheers in advance for any code/help/suggestions/roasted peanuts!

[VBA Noob]

Is it possible to force an excel file to close if someone disables macros?

The answer is no. However these links may help encourage users to enable them

http://www.vbaexpress.com/kb/getarticle.php?kb_id=379
http://www.cpearson.com/excel/EnableMacros.aspx

VBA Noob

[Thanatos]

The answer is no. However these links may help encourage users to enable them

http://www.vbaexpress.com/kb/getarticle.php?kb_id=379
http://www.cpearson.com/excel/EnableMacros.aspx

VBA Noob

Thx, will give those a try, although I may not be able to use them, as already have a macro in place that opens them on their personal page.

Out of curiosity, if they hit disable when prompted if they want to run the macro or not, wouldn't that prevent the sheets from being hidden (with the exception of the one that prompts for enabling the macro)?

[dominicb]

Good afternoon Thanatos

I have a template available that is designed to be used by multiple users. On opening the file a user is prompted for a username and password. Once validated, the user is only allowed to see sheets that the administrator has allowed. The administrator can see all sheets and assign read only / read-write access for any sheet for any user.

Obviously, this file needs to be opened with macros enabled, and the technique employed is similar to those detailed in the links that Noob has provided you with. The macros in this sheet are completely unprotected - if you would like a working example of how I achieved it, PM me your e-mail address and I'll forward the file on to you.

HTH

DominicB

[VBA Noob]

I may not be able to use them, as already have a macro in place that opens them on their personal page.

Not sure what you mean?

Out of curiosity, if they hit disable when prompted if they want to run the macro or not, wouldn't that prevent the sheets from being hidden (with the exception of the one that prompts for enabling the macro)?

You would hide the sheets first. If they disable macro they see the prompt screen. If they enable macros then the macro unhides them all.

VBA Noob