The standard way to approach this is as follows.
- create a worksheet with a message on explaining that for this workbook to
run it needs macros enabled, maybe even a few screenshots
- hide all other worksheets
- add some code in the Workbook_Open event that un hides the other sheets,
but hides that sheet.

What happens is that if they do not enable macros, they will only see the
warning sheet, telling them how to do it. If they enable macros,it will
startup the workbook as it should be.


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"K1KKKA" wrote in message
ps.com...
Ignore the above, have managed the code and works fine :)

But another question?

I have a macro that runs upon opening the workbook, is there a code i
could use that if the macros are disabled, then all sheets are hidden,
or the workbook will save/close if the disable option is chosen?


Steve