Prempt Disable Macros option

  • Thread starter Thread starter Fiona
  • Start date Start date
F

Fiona

I don't want to remove the virus protection by not giving people the
option to open a workbook with macros disabled but is it possible to
refuse to open a workbook if macros are disabled ?

I hope that makes sense :o)
 
Fiona,

If you mean that when they get the messagebox in which they van make the
choice to Diable or Enable macro's at the opening of the file, they can
refuse to open the file by clicking the X at the right top of the
messagebox.

Once they 've selected either Disable or Enable, the file is loaded without
further interruption.

Is this the answer you were after ?

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Fiona

If I'm reading this correctly, you have a workbook that needs macros enabled
in order to be functional.

If the user disables macros, you don't want the workbook to open.

Am I close?

See this google search thread for methods.

http://snipurl.com/4d8b

Dave Peterson has a couple of suggestions.

Gord Dibben Excel MVP
 
Back
Top