B
bondie
Is there any way that I can prevent the workbook from opening if th
user chooses to disable macros
user chooses to disable macros
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
I
immanuel
Nope. Not without using a non-MS addin or some other 3rd party means,
anyhow.
/i.
anyhow.
/i.
B
bondie
ok, thanks for your replies. I'll try to workaround the issues then
A
Alan
bondie said: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.
J
John Wilson
Alan,
Cool.....
John
Cool.....
John
Alan said: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.
B
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
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
A
Alan
bondie said: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.