| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
