Maximise Box

[Gregc.]

Hi

I am having trouble maximising my workbook. In the top right hand
corner, there is the minimise, maximise and close. For some reason on
this on this particular workbook it is missing. Would anyone know the
reason why?

Greg

 

[Mark Lincoln]

The workbook may be protected. In the later versions of Excel
protection can extend to the window size.

 

[Gregc.]

It is coming up with a Run time error 1005
Unable to set the WindowState property of the Window Class.

Greg

 

[Mark Lincoln]

Okay, we've rapidly moved out of my area of expertise and experience.
But since no one else has weighed in, I'll keep trying.

When do you get that error?

Does the dialog box give you a Debug option? (Meaning you can check
out VBA code that's causing the problem.)

Can you use the workbook afterward?

 

[Gregc.]

I solved it. I unprotected the workbook.

The weird part is, that when I re-protect the workbook, it works find.

Thanks for your help.

Greg

 

[Tom Ogilvy]

Workbook level protection has two contexts: Structure and Windows.
Protecting Windows would affect what you describe, so you probably didn't
protect windows.