-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Warning message
- Thread starter BarnBrian
- Start date
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,835
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
Hi Brian
For macro protection, do the following.
In the Project window of your code ( Top left hand side), right click on Microsoft Excel Objects, Select VBA Object Properties and then click on the protection Tab.
Tick the Lock Project Box and then input a password and confirm.
A word of warning though, this is a simple security system and easy to break, if one so wishes.
The other problem is that, if the user gets an error while using the macro the protection leaves them no option to Debug the problem. If your not available to help out, the user is stuck !!
HTH
Michael M
For macro protection, do the following.
In the Project window of your code ( Top left hand side), right click on Microsoft Excel Objects, Select VBA Object Properties and then click on the protection Tab.
Tick the Lock Project Box and then input a password and confirm.
A word of warning though, this is a simple security system and easy to break, if one so wishes.
The other problem is that, if the user gets an error while using the macro the protection leaves them no option to Debug the problem. If your not available to help out, the user is stuck !!
HTH
Michael M
Upvote
0
Excel Facts
Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Similar threads
- Question
