I'm pretty new to the whole VBA thing, and I've been trying to figure out how to format all sheets (about a hundred) in my workbook by creating macros.
What I would like to do is the following:
- Freeze the top row in every single sheet
I have used this code:- Create a button on every sheet that you can click on to go back to the first sheet
.SplitColumn = 0
.SplitRow = 1
ActiveWindow.FreezePanes = True
I created a button and linked it to this macro- Have the sheets open in A1 and not some random cell in the middle of the sheet
But I am not quite sure if this is the right way to do this.
Any thoughts on how to do this?I've found information on how to create macros for a single sheet, but can't seem to find out how to apply this to the whole worksheet.
Does anyone know how to do this?
Thanks a mill