ExcelBanter - Locking debug mode in a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Locking debug mode in a macro (https://www.excelbanter.com/excel-worksheet-functions/120919-locking-debug-mode-macro.html)

Megadrone

Locking debug mode in a macro

How do you lock someone for seeing your work when debug comes up?

Jim Thomlinson

Locking debug mode in a macro

You need to protect the project. In the VBE (Alt + F11) bring up the project
Explorer if it is not already visible (Ctrl + R). Right clcik the project
that you want to protect and select VBA Project Properties. Select the
Protection tab and add your password. Ensure that you have checked off Lock
Project for Viewing...

--
HTH...

Jim Thomlinson

"Megadrone" wrote:

How do you lock someone for seeing your work when debug comes up?

All times are GMT +1. The time now is 06:20 AM.