Excel 2004 - Reset formula bar using VBA

[XsilOnMac]

Version: 2004

Can anyone tell me if the following VBA code will work on a Mac?

I. What I'm trying to accomplish:
I need the formula bar to hide itself upon sheet activate, and reset upon deactivate.

II. Considerations:
I know the code works fine on PC/ Windows but need to build a cross platform solution (client uses both platforms), here so any /all VBA code needs to be universal. Also I would rather not instruct the end users (many novice excel people) to do this manually, as part of the goal is to minimize these types of tasks, hence the VBA code.

III. The code:

Private Sub Worksheet_Activate()
Application.DisplayFormulaBar = False
End Sub

Private Sub Worksheet_Deactivate()
Application.DisplayFormulaBar = True
End Sub

Thoughts?

Thanks!

 

[Bob Greenblatt]

Version: 2004

Can anyone tell me if the following VBA code will work on a Mac?

I. What I'm trying to accomplish:
I need the formula bar to hide itself upon sheet activate, and reset upon
deactivate.

II. Considerations:
I know the code works fine on PC/ Windows but need to build a cross platform
solution (client uses both platforms), here so any /all VBA code needs to be
universal. Also I would rather not instruct the end users (many novice excel
people) to do this manually, as part of the goal is to minimize these types of
tasks, hence the VBA code.

III. The code:

Private Sub Worksheet_Activate()
Application.DisplayFormulaBar = False
End Sub

Private Sub Worksheet_Deactivate()
Application.DisplayFormulaBar = True
End Sub

Thoughts?

Thanks!

It works fine on a Mac.