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
|
|
|