1
votes

I have multiple sheets, with the same cells and formats etc.

Is it possible to lock the same cells within each worksheet in the workbook? I am hoping this is possible via VBA. I know I can do this manually for each sheet, but I've got around 50 sheets.

Thanks for your help.

1

1 Answers

1
votes

Check this out:

http://software-solutions-online.com/excel-vba-formating-cells-and-ranges/

You can create a macro with this tutorial for formatting and call it from your vba code.

If it helps I would be happy about an mark :)