Results 1 to 7 of 7
  1. #1
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    VBA Module Format (MOS 2003)

    Below is a series of macros to attach to buttons on a tool bar.

    Except in the menu, there is a "divide line" or group separator, after line 9. What could cause this line to be present?

    Regards,
    Chuck Billow

    ****************

    Sub FeedDemon()
    Shell ("C:WinAppsCommInternetNewsFeedDemonFeedDemon.exe" ), vbNormalFocus
    End Sub
    Sub Google()
    Shell ("C:WinAppsCommInternetGoogleGGSearchToolggsearch. exe"), vbNormalFocus
    End Sub
    Sub PSACards()
    Shell ("C:WinAppsInfoPSA Cardscards.exe"), vbNormalFocus
    End Sub
    Sub TenKey()
    Shell ("C:Windowscalc.exe"), vbNormalFocus
    End Sub
    Sub WOPR()
    Shell "crogram filesinternet exploreriexplore.exe http://www.wopr.com/cgi-bin/w3t/login.pl?Cat=", vbNormalFocus
    End Sub
    Sub AgentNews()
    Shell ("C:WinAppsCommInternetNewsAgentagent.exe"), vbNormalFocus
    End Sub
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA Module Format (MOS 2003)

    The separator has nothing to do with these macros. You can remove it as follows:
    - Select Tools | Customize...
    - Click on the relevant menu to make it drop down.
    - Click on the item just below the separator.
    - Drag it upwards just a little bit and release it. This should make the separator disappear.
    - Click the Close button in the Customize dialog.

  3. #3
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: VBA Module Format (MOS 2003)

    Hans:

    What the heck put it there?

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA Module Format (MOS 2003)

    You, probably. Who else?

  5. #5
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: VBA Module Format (MOS 2003)

    Hans:

    Yea... OK ... but how? I didn't do anything that I recall to the menu itself, and, as you noted, it wasn't in the macros... It was a "Group" marker?!

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA Module Format (MOS 2003)

    Those menu items are not built-in, so they must have been created by you. I'd guess you accidentally dragged one item a little bit downwards, causing a separator to appear.

  7. #7
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: VBA Module Format (MOS 2003)

    Gotta watch that... thanks Hans.

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

Posting Permissions

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