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 |
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 |
All times are GMT +1. The time now is 01:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com