Macro to unlock a range on specific worksheets in workbook.

[alex50266]

Hello, I have a number of workbooks with about 30 worksheets in each book that I use for clients to submit expenses to me. When I sent the books out for the new fiscal year, I protected them and inadvertently locked the cells in which the clients are to enter data.

I recorded a macro to unlock the cells for me, and it works for the Jul Expenses sheet, but I can't seem to figure out how to make it apply to the selected sheets in the workbook.

The macro was recorded using the "Jul Expenses" sheet, but there are sheets for all months Jul Expenses, Aug Expenses, Sep Expenses all the way through Jun Expenses. All of the monthly sheets are identical except for the month indicated.

Can anyone help me adjust the code to apply to all of the monthly expense sheets and not just the Jul Expenses sheet?

Please Login or Register  to view this content.

[sintek]

Welcome to the forum...Give this a go...Untested.
Can test if you upload a sample file..

Please Login or Register  to view this content.

[alex50266]

This worked perfectly. Thank you. I did add my protection password to the vba code to eliminate having to type the PW in 12 times.

Thanks again!

[sintek]

Pleasure...Thanks for rep +. Please mark thread as solved...