Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd - when saving wb & protected...it opens with sheet 'down'
Hi -
I am using the good ole technique for macros not being enabled of creating a worksheet that says 'your macros are not enable...do this'. So, when I close and save, I leave it on this sheet. I am also password protecting the workbook when I close. When the user opens the workbook, the first vb runs and hides that 'no macros' sheet and goes to the correct sheet. Now for the wierd part. Since the workbook is saved protected, when the workbook opens and the user does not have macros enabled, my 'no macro' sheet only opens as if it is 'down' (not maximized, but not minimized...not sure what you really call it). If I do not protect the workbook when I save it, the no macro sheet will be maximized. What gives? Thanks is advance. Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted Prompt When Saving a Protected Sheet in 2007 | Excel Discussion (Misc queries) | |||
Password Protected Excel Spreadsheet opens blank | Setting up and Configuration of Excel | |||
Wierd!!!!?? Protected and shared - cant insert hyperlink | Excel Discussion (Misc queries) | |||
Workbook opens really small after protected | Excel Programming | |||
Protected Workbook Opens Restored | Excel Programming |