 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2006Maximise 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 The workbook may be protected. In the later versions of Excel protection can extend to the window size. It is coming up with a Run time error 1005 Unable to set the WindowState property of the Window Class. Greg 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? 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 Workbook level protection has two contexts: Structure and Windows. Protecting Windows would affect what you describe, so you probably didn't protect windows.  SignatureRegards, Tom Ogilvy > I solved it. I unprotected the workbook. > [quoted text clipped - 3 lines] > > Greg |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.