Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I have used this code to increase the height of the formula bar when the particular sheet 'Race Log' is activated and which works fine.
However, when I open any of the other 15 sheets in the workbook after this sheet, the height remains increased and the only way I know to reduce it is to use similar code in all the other sheets
Is there a better way to do this?
Thanks
I have used this code to increase the height of the formula bar when the particular sheet 'Race Log' is activated and which works fine.
VBA Code:
Private Sub Worksheet_Activate()
Application.FormulaBarHeight = 2
End Sub
VBA Code:
Private Sub Worksheet_Activate()
Application.FormulaBarHeight = 1
End Sub
Thanks