Results 1 to 15 of 15
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Georgetown, Grand Cayman, Cayman Islands
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA in Office XP (OXPSP2)

    In any office app, I hit Alt-F11 to bring up the VBA editor and nothing happens.
    I tried going tools>macro>VBA Editor and nothing happens.

    I dont get an error or anything, just... nothing! [img]/forums/images/smilies/smile.gif[/img]

    Im fresh out of ideas, has anyone seen this behaviour before?

    Thanks
    Mark

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: VBA in Office XP (OXPSP2)

    Are you sure that VBA was installed as part of the Office installation?
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Georgetown, Grand Cayman, Cayman Islands
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    OMG I never even thought of that! [img]/forums/images/smilies/smile.gif[/img] OXP was pre-installed on my machine when I got it.. you'd think that when I invoked it the first time it would bring up the installer and give me the "this isnt installed, you goof" error [img]/forums/images/smilies/smile.gif[/img]

    I'll look into that and let you know [img]/forums/images/smilies/smile.gif[/img]

    Mark

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    I have a similar problem, but only with Word. Alt-F11 does not bring up the VB editor. I have not taken the time to find out why, but VBA was and is installed.

    Can you access VBA from Tools, Macro, Visual Basic Editor ?

    Andrew C

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    Georgetown, Grand Cayman, Cayman Islands
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    Just checked, and VBA is installed, plus I also have Visual Studio 6 installed as well.

    I cant fire it up from alt-f11 or tools>macros>vba editor

    Mark

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    Have you tried in each of the Office apps?

  7. #7
    Star Lounger
    Join Date
    Feb 2001
    Location
    Georgetown, Grand Cayman, Cayman Islands
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    I checked to see if it was installed and it was. I was going to un-install it and re-install it, but it gave me a warning that if I un-installed VBA it would un-install Access as well. Im not QUITE ready to do something as drastic as re-installing Office, but it's on the list and Im coming up to it quickly [img]/forums/images/smilies/smile.gif[/img]

    In Access, Alt-f11 brings up the editor.
    In Excel it works
    in Outlook nothing happens
    in Publisher it works
    in Word it works
    in Frontpage it works
    nothing happened in Money, but I didnt expect it to [img]/forums/images/smilies/smile.gif[/img]

    OK so Ive narrowed it down to Outlook (ironically the app I wanted to use it for [img]/forums/images/smilies/smile.gif[/img]

    Mark

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    What about Powerpoint?

  9. #9
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    Don't unstall.
    If anything, use Add/Remove programs to add missing components and use Office's Repair tool.

  10. #10
    Star Lounger
    Join Date
    Feb 2001
    Location
    Georgetown, Grand Cayman, Cayman Islands
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    Yes powerpoint works too.. I didnt check it because I hardly ever uuse it and it was "hidden" in my start menu. [img]/forums/images/smilies/smile.gif[/img]

    Do you think it's maybe something to do witha security setting within Outlook? I have Slovaktech's ATTOPT and cloudmark's spam filter add-ins installed as well.

    Mark

  11. #11
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    Remove the add-ins and see what happens.

  12. #12
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA in Office XP (OXPSP2)

    Before you do anything else, try opening the VBE using Tools-->Macro-->Visual Basic Editor. Once you've opened it that way, you should be able to use the shortcut. Don't ask me why, but that worked on my Outlook 2k. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  13. #13
    Star Lounger
    Join Date
    Feb 2001
    Location
    Georgetown, Grand Cayman, Cayman Islands
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    Yeah Ive tried that. I did it again right after getting your email. when I clicked it, I got a brief flash of an hourglass, but still nothing.

    I cant open Macros or Security menu items either, in the same flyout.

  14. #14
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA in Office XP (OXPSP2)

    That sounds like one of the draconian security patches installed with SP2. Sorry I can't help.
    Charlotte

  15. #15
    Star Lounger
    Join Date
    Feb 2001
    Location
    Georgetown, Grand Cayman, Cayman Islands
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA in Office XP (OXPSP2)

    UGH. that would suck. Complete removal of macros and VBA from Outlook as part of OXPSP2? I dont remember reading that anywhere..

    Does anyone have any more on that?

Posting Permissions

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