From: Brick61 on
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
>
> .
>