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?