Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stop a Start-up Macro (excel 2003)

    I put a startup macro in a spreadsheet to automatically sort a list of payment dates which automatically refresh based upon a system of vlookups and a today formula on a calculations sheet, in short, the closest payment dates are always at the top of the list. I closed the workbook on the calculations sheet sheet and now the startup macro is sorting all of my calculations data instead of the payment schedule. How do I stop a start-up macro? Can I get into vbe and edit is without opening the spreadsheet? I tried holding down shift while starting the sheet but that didn't work.

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

    Re: Stop a Start-up Macro (excel 2003)

    Holding down Shift while opening the workbook should work. Make sure that you hold down the Shift key until the workbook has fully opened.

    Also: has macro security been set to Low (in Tools | Macro | Security)? If so, set it to Medium. When you open the workbook, you'll be asked whether to enable or disable macros. Select Disable Macros. This will prevent the startup macro from running without holding down Shift.

Posting Permissions

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