I have a new computer at home and have moved (copied) a lot of my Excel stuff
from my work computer to my new computer. Things run relatively smoothly,
but there are a couple of things I don't understand.

1) If I open VB from a spreadsheet - View, Toolbars, Visual Basic, VB
Editor - and open a module, the screen is blank - the module shows nothing in
it. If I go to Tools, Macros, and select a particular Macro, it pulls up the
module and shows the code.

2) I am using the following to re-size the VB code windows:

Dim cmpComponent As VBIDE.VBComponent
Dim cmpComponents As VBIDE.VBComponents
. . . .
Set cmpComponents = ThisWorkbook.VBProject.VBComponents

and running through each module to size the window the way I want it. If I
step through the code, it shows that the windows are being resized. I close
and save the spreadsheet, but when I reopen the spreadsheet, the code windows
are back to the default size.

Any thoughts?

--
Bill @ UAMS

in vba toolbars have a look in
toolsoptionseditor

--
Don Guillett
SalesAid Software

"BillCPA" <Bill @ UAMS wrote in message
...
I have a new computer at home and have moved (copied) a lot of my Excel
stuff
from my work computer to my new computer. Things run relatively smoothly,
but there are a couple of things I don't understand.

1) If I open VB from a spreadsheet - View, Toolbars, Visual Basic, VB
Editor - and open a module, the screen is blank - the module shows nothing
in
it. If I go to Tools, Macros, and select a particular Macro, it pulls up
the
module and shows the code.

2) I am using the following to re-size the VB code windows:

Dim cmpComponent As VBIDE.VBComponent
Dim cmpComponents As VBIDE.VBComponents
. . . .
Set cmpComponents = ThisWorkbook.VBProject.VBComponents

and running through each module to size the window the way I want it. If
I
step through the code, it shows that the windows are being resized. I
close
and save the spreadsheet, but when I reopen the spreadsheet, the code
windows
are back to the default size.

Any thoughts?

--
Bill @ UAMS