Hiding formula bar/scroll bar in specific spreadsheet only

[surkdidat]

Good morning

I have VBA to hide the formula bar/scrollbar etc on my spreadsheet.

However, this seems to then replicate this action on any spreadsheets that are opened.

I only need it in a specific workbook only, and I do not want it to affect any other workbooks.

Can anyone please advise if this is:
a) Possible
b) If yes, how to do this.

Application.EnableEvents = True
Application.DisplayFormulaBar = False
Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"",False)"
    Application.DisplayStatusBar = False
    ActiveWindow.DisplayWorkbookTabs = False
    ActiveWindow.DisplayHeadings = False
    Sheets("newmultirate").ScrollArea = "A1:S28"

 

[Yongle]

Try puttings setting back to normal when the workbook is deactivated and re-applying the settings when the workbook is activated
Both procedures must be place in ThisWorkbook module

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    [COLOR=#008080][I]put setting back to normal in this procedure[/I][/COLOR]
End Sub
Private Sub Workbook_Activate()
    [COLOR=#008080][I]apply special ribbon \ scroll \ formula bar settings in this procedure[/I][/COLOR]
End Sub