LOL - No - don't you think the virus writers would love that :-)

But - what you can do though, is hide all the salient sheets in the workbook,
leaving a sheet that explains they will not see anything at all until they
enable macros before opening the workbook. Then, in the workbook_open event,
have some code display all the sheets but hide the warning sheet. If you hide
the sheets to start with using the xlveryhidden option, then they won't even
know they are there if they open it without macros and poke around.

Now, if they open without macros enabled, they get a warning and no data, but as
long as they are enabled, they just get the data.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"pgjoshi " wrote in message
...
Can I force the user to enable macros before opeining workbook
containing macros?


---
Message posted from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.613 / Virus Database: 392 - Release Date: 04/03/2004