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" wrote in message
om...
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)

Consider putting your macros in an add-in. See
http://www.mrexcel.com/board2/viewto...=148963#148963 for more.

But, if you insist on a quick and dirty way, check
http://www.mrexcel.com/board2/viewto...=142023#142023

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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 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

On 8 Feb 2004 06:04:28 -0800, (Fiona) wrote:

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)