make sure sheet is protected

jjsanders

New Member
Joined
Oct 16, 2006
Messages
36
I need for my sub to make sure that the current sheet is protected. How can i arrange this with VBA?
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Macropheliac

Board Regular
Joined
Aug 26, 2005
Messages
165
Depends on the code. Maybe just add:
Code:
ActiveSheet.Protect
At the end of the procedure.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,734
Members
410,702
Latest member
clizama18
Top