Wierd - when saving wb & protected...it opens with sheet 'down'

[Guest]

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

 

[Guest]

Hi Mike,

Maybe you set the windowstate is minimized,
Perhaps you can place it in ThisWorkbook module :

Private Sub Workbook_Open()
Application.ActiveWindow.WindowState = xlMaximized
End Sub

 

[Guest]

Hi - thanks for the advice. Unfortantly, when the macros are disable, the
Workbook_Open() won't work. I did put this code before I protect and save,
but it did not work.

Can anyone else help? Thanks,
Mike

 

[NickHK]

When you protected the WB, did you check "Windows" as well as "Structure" ?
Try it without the "Windows" checked.

NickHK

 

[Guest]

Hi Nick - you nailed it! Works fine now. Thanks!
Mike

 

[Tim Mayes]

Mike,

I do something similar, but without the password protection. However, I use the
BeforeSave or BeforeClose event to save the workbook with all sheets very
hidden, except for the "note" sheet. That way, if macros are disabled, the
sheets are already hidden. I don't know if that will change your workbook
opening minimized, but I've never had that happen.