View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default ActiveWindow.Width no longer works for me!

If the window is maximized this error will occur. Try making sure the
window is in the restored state:

With ActiveWindow
.WindowState = xlNormal
.Width = 420
.Height = 260
End With


--
Jim Rech
Excel MVP
"rickety" wrote in message
...
| I'd appreciate any pointers to help solve a problem.
|
| Since upgrading to Office 2003 and when using an Excel application (Excel
| version 11.5612.5703) I get an error
|
| Runtime error '1004' Unable to set the Width property of the Window class.
|
| The help does not hint (to me) at what might be the cause.
|
| There are several places where I use this similar approach
|
| ========================
| code snippet
|
| Worksheets("StartForm").Activate
|
|
| With ActiveWindow
| .Width = 420
| .Height = 260
| End With
|
|
| etc.
| =======================
|
| --
| Rickety
|
|