What I did was to create a separate worksheet with a notice saying "Macros
must be enabeled to view data". This sheet is visible; all others are
xlVeryHidden. A macro runs on workbook open - *if* macros are enabled -
with a button to hide the notice sheet and open the data sheets. The notice
also says "If you don't see the button, close this file, set macro security
to medium, and re-open."

HTH
Ed

"David Bell" wrote in message
...

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