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)