Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hello
I created a simple msgbox to remind me to unprotect a particular worksheet that is protected when the workbook is opened (there are 12 other tabs that aren't protected).
Is it possible for a line or two of code that stops any further (irrelevant) messages when I have unprotected the sheet, while the workbook is still open?
Thanks!
I created a simple msgbox to remind me to unprotect a particular worksheet that is protected when the workbook is opened (there are 12 other tabs that aren't protected).
VBA Code:
Private Sub Worksheet_Activate()
MsgBox "Unprotect Worksheet ", vbInformation, "Daily Tracking"
Is it possible for a line or two of code that stops any further (irrelevant) messages when I have unprotected the sheet, while the workbook is still open?
Thanks!