I'm wanting to use a macro to freeze all selected sheets using the same cell for all sheets. So far I have:
Sub FreezePanes()
Range("F7").Select
With ActiveWindow
.FreezePanes = False
.FreezePanes = True
End With
End Sub
The only issue is I need to manually change the cell value in VBA. Is there a way to have an input box come up to enter the cell value?
Sub FreezePanes()
Range("F7").Select
With ActiveWindow
.FreezePanes = False
.FreezePanes = True
End With
End Sub
The only issue is I need to manually change the cell value in VBA. Is there a way to have an input box come up to enter the cell value?