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
Bookmarks