Hide Formula Bar on Selected Sheets

[lapta301]

Dear All

I have been using the following code to turn on and off the Formula Bar when a specific workbook containing one sheet is opened and closed.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayFormulaBar = True
End Sub

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


However, I now have a need to turn it off for this one particular sheet but turned back on for other new sheets in the same workbook. Can this be achieved?


As always many thanks for any help you can provide.

Lapta301

 

[GTO]

If it is only for one particular sheet in the workbook - right-click the sheet's tab and select View Code. You can use the sheet's Activate and Deactivate events.

Hope this helps,

Mark

 

[lapta301]

GTO

Thank you, it works a treat other than one minor issue.

If the file was saved with, in this case the sheet "HowTo" active where the formula bar should be hidden then it reopens on that sheet with the formula bar visible. That will change when you activate another sheet so how do I ensure that the workbook opens on the sheet "Stats" regardless of what was active at the time of saving.

Sorry if I'm rambling but I hope this makes sense.

Many thanks for taking the time to help me.


lapta301

 

[lapta301]

GTO

Not to worry I have found the answer to this minor issue elsewhere.

Again my sincere thanks for taking the time to answer my initial problem

Regards



Lapata301

 

[GTO]

Most happy to help