Unlocking multiple sheets at once

[Jhertilus]

I created a workbook that has sheets for 100 clients, unfortunately I made the same formatting error on each sheet. If I wanted to format cells A1:D4 to be centered bold and colored black is there any way I could do that globally without having to unlock each individual sheet and reforming the same cell field for each sheet?

I'm not sure if I could take any more copy pasting... Thanks!

[stnkynts]

I don't know what you mean by locked

Please Login or Register  to view this content.

[Jhertilus]

I mean all the sheets are protected... Can I put that into a module? Does it matter that the worksheets are named person1,person2 etc?

[FDibbins]

A quick tip on working with multiple worksheets, if you want to do the same on each 1...

Click on the 1st sheet in the range.
Hold SHIFT and click on the last sheet in the range.
all those sheets are now in GROUP mode - what you do to 1, will be "punched through" to all the sheets. It wont work with unprotecting sheets though

MAKE sure you "ungroup" the sheets by clicking on a sheet outside the group, or by rt clicking on a sheet tab and selecting UNGROUP

[stnkynts]

Please Login or Register  to view this content.

[Jhertilus]

I have to get to sleep but ill try this tomorrow. Thanks, you're a lifesaver

[Jhertilus]

Perhaps I put this in the wrong location but it didn't work. Where am I supposed to paste this?

[stnkynts]

In the visual basic editor, create a new module and put it there. If still confused on where to put it, do a google search.

[Jhertilus]

Thank you so much