Auto_Open Macro
in [Programming]
|
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 12:35 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
From: ryguy7272 on 25 Mar 2010 13:39 I'm still getting used to 2007 too. Look at this: http://office.microsoft.com/en-us/excel/HP100969191033.aspx I think that's all there is to it. -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Brick61" wrote: > 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
From: Brick61 on 25 Mar 2010 14:34 All this does is tell me how to change my security settings. I want to enable the Auto_Open macro and prevent it from running, so that I can edit before it runs. -- Brick61 "ryguy7272" wrote: > I'm still getting used to 2007 too. Look at this: > http://office.microsoft.com/en-us/excel/HP100969191033.aspx > > I think that's all there is to it. > > -- > Ryan--- > If this information was helpful, please indicate this by clicking ''Yes''. > > > "Brick61" wrote: > > > 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
From: Gary Keramidas on 25 Mar 2010 14:39 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
From: Brick61 on 25 Mar 2010 15:15
That doesn't seem to work with Excel 2007. -- 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 > > . > |