First, set a reference (VBA Editor Tools menu, References) to the
"Microsoft Visual Basic For Applications Extensibility 5.3"
library. Then you can use the Window object to control the
Window properties of a specified CodePane.
With
ThisWorkbook.VBProject.VBComponents("Module1").Cod eModule.CodePane.Window
Debug.Print .Top, .Left, .Height, .Width
End With
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"BillCPA" <Bill @ UAMS wrote in message
...
Is there any way to set the parameters (or change the default
parameters) for
the various VBA windows - code, properties, etc. - to control
where they
display on the screen and their size?
--
Bill @ UAMS