Ken,

The standard approach to this problem is to hide all sheets
except a "welcome" sheet. In the Workbook_Open event, you display
all your worksheets. In the Workbook_BeforeClose event, hide
(xlVeryHidden) all your worksheet except the "welcome" sheet. If
macros are not enabled, all the user will see is the welcome
sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"holy41" wrote in message
...
I need to Put formula in macro to run a work sheet so if the
macro are turn
off the
program won,t run.
Can anyone help me ?
Ken