protect macro

[david graham]

I need a macro that will protect all sheets in my wb.

I only want to be able to select unlocked cells

 

[crimson_b1ade]

why a macro? you can do that manually with ease.

 

[crimson_b1ade]

also, try searching the board...this is what I found which is similar to your request: http://www.mrexcel.com/forum/showthread.php?t=371749&highlight=protect+sheets

 

[Michael M]

Hi David
Try:

Change "password" to suit.

Sub unprotect_all_ws()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Unprotect "password"
Next ws

End Sub
Sub protect_all_ws()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Protect "password"
Next ws

End Sub

 

[david graham]

Thanks michael.


Crimson Blade, could you please not respond to any more of my posts, thanks so much

 

[tusharm]

Care to share why?

Thanks michael.


Crimson Blade, could you please not respond to any more of my posts, thanks so much