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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 spreadsheet I check "Lock" for all cells.  Then turn on the
> > > "Protection" for the sheet.  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 spreadsheet.
> > > 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
> >
> >
> >

Relevant Pages

  • Re: I want the macros to be locked up when cells are locked up.
    ... I looked at the "Tools> VBAproject Properties" and am unable to figure out ... Could you give me sample entries that would protect VBA code? ... Also you cannot right click a Macro ...
    (microsoft.public.excel.programming)
  • Re: disabling/enabling a control on a menu
    ... what is the vba code to select a specific id of a control and then set the ... enable value to false rather than looking for the name of the control. ... i.e the protect document button has an id no of 336 how do i use this to ... Doug Robbins - Word MVP ...
    (microsoft.public.word.vba.general)
  • Re: Vissible Field
    ... macro or VBA code to show/hide a control on a form - but ... but the control will be hidden for all records, ...
    (microsoft.public.access.forms)
  • Re: How do I protect my code?
    ... How to run macro from another workbook using Alt + F8 ... Maybe you can move your code into an addin and protect that the way you want. ... Or ask him to put his macro into another workbook and use alt-f8 to run it. ... So is it possible to just protect my vba code and let him create his macros? ...
    (microsoft.public.excel.programming)
  • Re: How do I protect my code?
    ... Not in the same workbook project. ... Maybe you can move your code into an addin and protect that the way you want. ... Or ask him to put his macro into another workbook and use alt-f8 to run it. ... So is it possible to just protect my vba code and let him create his macros? ...
    (microsoft.public.excel.programming)