Maximise Box
 

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

Maximise Box
 

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

Maximise Box
 

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

Greg

Maximise Box
 

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?

Maximise Box
 

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

Maximise Box
 

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

--
Regards,
Tom Ogilvy

"Gregc." wrote in message
oups.com...
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