protected workbook for windows

[Hendon]

I wish to apply workbook protection and protect for windows. Is there any way
of instructing the workbook to open to a specific size (eg full-screen). I
cant quite see the point of protecting for windows if Excel simply decides
the window size!

 

[Gord Dibben]

Before protecting the workbook, un-maximize it and resize to full size.

Then protect with windows and structure checked.

Save and close.

The workbook will open to the size you saved with.


Gord Dibben MS Excel MVP