Thread: macro

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

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" <holy41@discussions.microsoft.com> wrote in message
news:B1265D21-43A2-448A-8208-94836806C5A1@microsoft.com...
>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