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

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

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

Hi Ed

You can protect your VBA code in the VBA editior
Alt-F11
ToolsVBAproject properties


--
Regards Ron de Bruin
http://www.rondebruin.nl



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

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



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

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



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

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

Hi Ed

Om the protection tab fill in a password (two times) and mark "Lock project for viewing".
Then Save/Close/reopen the file

You can't do this with code (it is possible with Sendkeys but this is not reliable)


--
Regards Ron de Bruin
http://www.rondebruin.nl



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


--
Regards Ron de Bruin
http://www.rondebruin.nl



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

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

Hi Ron
Problem solved. It was so simple.
Thankyou again.
Ed

"Ron de Bruin" wrote:

Hi Ed

Om the protection tab fill in a password (two times) and mark "Lock project for viewing".
Then Save/Close/reopen the file

You can't do this with code (it is possible with Sendkeys but this is not reliable)


--
Regards Ron de Bruin
http://www.rondebruin.nl



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


--
Regards Ron de Bruin
http://www.rondebruin.nl



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

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

Thank You All
It solved the same problem for me.

BobCarter
Douglas, MA

"Ed" wrote:

Hi Ron
Problem solved. It was so simple.
Thankyou again.
Ed

"Ron de Bruin" wrote:

Hi Ed

Om the protection tab fill in a password (two times) and mark "Lock project for viewing".
Then Save/Close/reopen the file

You can't do this with code (it is possible with Sendkeys but this is not reliable)


--
Regards Ron de Bruin
http://www.rondebruin.nl



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


--
Regards Ron de Bruin
http://www.rondebruin.nl



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