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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ed (Ed_at_discussions.microsoft.com)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 07:37:02 -0800

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
>
>
>

Quantcast