+ Reply to Thread
Results 1 to 2 of 2

VB - Weird Things on New Computer

  1. #1
    BillCPA
    Guest

    VB - Weird Things on New Computer

    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

  2. #2
    Don Guillett
    Guest

    Re: VB - Weird Things on New Computer

    in vba toolbars have a look in
    tools>options>editor

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "BillCPA" <Bill @ UAMS> wrote in message
    news:208775E2-EFF3-4722-B3E0-CC1B0A4575AF@microsoft.com...
    > 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




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1