Hi there,
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 sheetI have used this code:
Sub freeze()
With ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
ActiveWindow.FreezePanes = True
- Create a button on every sheet that you can click on to go back to the first sheetI created a button and linked it to this macro
Sub BackToFirstSheet
Sheets("Sheet1").Select
End Sub
But I am not quite sure if this is the right way to do this.
- Have the sheets open in A1 and not some random cell in the middle of the sheetAny 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
Bookmarks