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