Re: I want the macros to be locked up when cells are locked up.

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 10:44:35 -0500

There is not code associated with it. It is an option you select.

Also, you need look at the EnableCancelKey property to have better control
in your macro. You can then have code execute that will avoid the debug
message and exit more gracefully. 

-- 
Regards,
Tom Ogilvy
"Ed" <Ed@discussions.microsoft.com> wrote in message
news:3316426E-682A-4A70-B14B-FE4993355A6B@microsoft.com...
> Hi Ron
> Thanks for the response.
> I looked at the "Tools > VBAproject Properties" and am unable to figure
out
> what the coding would be.
> Could you give me sample entries that would  protect VBA code?
> Thankyou
> Ed
>
>
> "Ron de Bruin" wrote:
>
> > Hi Ed
> >
> > You can protect your VBA code in the VBA editior
> > Alt-F11
> > Tools>VBAproject properties
> >
> >
> > -- 
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> >
> > "Ed" <Ed@discussions.microsoft.com> wrote in message
news:E03AF080-0643-47B6-B862-67513E3FD397@microsoft.com...
> > > On my spread*** I check "Lock" for all cells.  Then turn on the
> > > "Protection" for the ***.  In this condition, no one can enter or
change
> > > any information in any of the cells.  Also you cannot right click a
Macro
> > > control button and edit the Macro.  This is great.
> > >
> > > However, my Macro controls the operation of the spread***.
> > > When you click start, the operation begins and repeats the operation
over
> > > and over again continuously without stopping until you press "ESC".
When you
> > > press "ESC", the operation stops, as it should.  Now in this stopped
> > > condition, a window  appears on the screen which (amoung other
buttons)
> > > contains the button "Debug".
> > > Even when the Protection is on, you can click this button and it gives
you
> > > access to the Macro contents.  You can change anything you want to, it
is not
> > > Protected.
> > > Is there a way to Protect the contents of the Macro by preventing any
access
> > > when you click the "Debug" button?
> > >
> > > I would appreciate any help you can give.
> > > Thankyou
> > > Ed
> >
> >
> >