Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2009
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an excel spreadsheet that has an On Open event. This event kicks off a series of macros and code to do alot of data gathering from an Access database and then saves the workbook as another workbook without macros and then closes the original workbook. My issue is now, I have to get into the workbook and make modifications to the code. I can not open it as it runs the macros and code. Is there a manual way (like in Access holding down the Shift key) to bypass the vba and macros?

    Thanks,
    Cindy
    York, PA

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Cindy,

    One way to do it is to open Excel
    Press Alt+F11 to get into the VBA Editor
    In the immediate window use the workbooks.open command to open the workbook.

    Ex: workbooks.open "d:\path\filename.xls"

    If the Immediate window isn't visible use the View menu or press Ctrl+G

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    towcester, england, UK
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Cindy

    pressing Shift when opening the workbook should work in Excel too.

    alternatively, drop your office security settting to medium and when prompted to enable/disable macros, choose disable....

    Cheers
    Phil

Posting Permissions

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