Prevent workbook from opening if macros are disabled

[bondie]

Is there any way that I can prevent the workbook from opening if th
user chooses to disable macros

 

[John Wilson]

bondie,

Sorry, but that can't be done.
What can be done (and you have some answers in your previous post)
is to make the workbook unusable if macros are disabled.

Please note that Excel is by no means secure.
Even if you protect and lock the VBA code, it's quite simple for an
experienced user to crack it. There are also programs for sale
on the net that crack VBA protection.
Once they get into the code, whatever you wrote in there to
protect your work is futile.

John

 

[immanuel]

Nope. Not without using a non-MS addin or some other 3rd party means,
anyhow.

/i.

 

[bondie]

ok, thanks for your replies. I'll try to workaround the issues then

 

[Alan]

Is there any way that I can prevent the workbook from opening if the
user chooses to disable macros?

Hi Bondie,

Yes - you can do this.

Have a look at this thread from September 2003:

http://groups.google.co.nz/groups?h...rosoft.public.excel.*&scoring=d&start=20&sa=N

And perhaps most usefully, this posting within that thread:

http://groups.google.co.nz/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&[email protected]

HTH,

Alan.

 

[John Wilson]

Alan,

Cool.....

John

Hi Bondie,

Yes - you can do this.

Have a look at this thread from September 2003:

http://groups.google.co.nz/groups?h...rosoft.public.excel.*&scoring=d&start=20&sa=N

And perhaps most usefully, this posting within that thread:

http://groups.google.co.nz/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&[email protected]

HTH,

Alan.

 

[bondie]

Hi Alan.. thanks for the tip. I have tried adding the code but it di
not work as expected. I'm not sure if there's something I've missed bu
is it suppose to open (but show the Macro1 sheet) when I disabl
macros

 

[Alan]

Hi Alan.. thanks for the tip. I have tried adding the code but it did
not work as expected. I'm not sure if there's something I've missed
but is it suppose to open (but show the Macro1 sheet) when I disable
macros?

Hi Bondie,

Just run the code once in any workbook, and it will add the
Excel4Macro sheet.

Once you have done that, the workbook contains a macro, so the
dialogue comes up when you open it, and it is an Excel4 Macro, so
disabling causes excel not to open the file at all.

HTH,

Alan.