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

I'm still getting used to 2007 too. Look at this:
http://office.microsoft.com/en-us/ex...969191033.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

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/ex...969191033.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

hold down the shift key when you open it.

--


Gary Keramidas
Excel 2003


"Brick61" wrote in message
...
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

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" wrote in message
...
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

.

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" wrote in message
...
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

.