Prev: Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1 to be repeated at top
Next: How do I open a com port using Excel visual basic
From: Brick61 on 25 Mar 2010 15:31 Sorry for the earlier post. I was trying to hold the shift key after I opened, not when I opened it. Thanks -- Brick61 "Gary Keramidas" wrote: > hold down the shift key when you open it. > > -- > > > Gary Keramidas > Excel 2003 > > > "Brick61" <Brick61(a)discussions.microsoft.com> wrote in message > news:B2F22033-66B1-4366-BECD-EFFC748A442F(a)microsoft.com... > >I have several auto_open macros that were created with Excel 2003. To > >enable > > the macro and preventing it from running, I set my security to medium and > > hold down the shift key when clicking 'enable macro'. > > > > How can I achieve the same with Excel 2007 so that I can enable the macro, > > without it running, and then edit if necessary? > > -- > > Brick61 > > . > |