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

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

--

Regards,

Halim


"Mike R." wrote:

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

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

"Halim" wrote:

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

--

Regards,

Halim


"Mike R." wrote:

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

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

NickHK

"Mike R." wrote in message
...
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

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

"NickHK" wrote:

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

NickHK

"Mike R." wrote in message
...
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

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.

Mike R. wrote:
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

"Halim" wrote:

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

--

Regards,

Halim


"Mike R." wrote:

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