Force Enable Macros
 

Hi David,

No, not really. If so, the virus writers would have a grand old time!

But there are some things you can do:

1) Digitally sign your VBA project - this will allow users to accept your
VBA projects once, then macros will be enabled anytime a project signed by
you is opened. Do a search for "selfcert.exe" on the MS site and you'll
find more info on this.

2) Disable all features by default, and then enable them all in the
Worksheet_Open routine. That way, if the user disables macros, your
workbook will be pretty close to useless. Some ideas: make all sheets
xlVeryHidden, protect the worksheets/workbook with a password,
password-protect your VBA project.

--
Regards,

Jake Marx
MS MVP - Excel

David Bell wrote:
Is there anyway to force users to enable macros.... ie
file doesn't open unless macros are enabled?

Force Enable Macros
 

What is the one line of code that enters a password upon
opening a workbook with enabled macros?

Thanks.

-----Original Message-----
Hi David,

No, not really. If so, the virus writers would have a
grand old time!

But there are some things you can do:

1) Digitally sign your VBA project - this will allow
users to accept your
VBA projects once, then macros will be enabled anytime a
project signed by
you is opened. Do a search for "selfcert.exe" on the MS
site and you'll
find more info on this.

2) Disable all features by default, and then enable them
all in the
Worksheet_Open routine. That way, if the user disables
macros, your
workbook will be pretty close to useless. Some ideas:
make all sheets
xlVeryHidden, protect the worksheets/workbook with a
password,
password-protect your VBA project.

--
Regards,

Jake Marx
MS MVP - Excel

David Bell wrote:
Is there anyway to force users to enable macros.... ie
file doesn't open unless macros are enabled?

.