How to restrict view for users of a spreadsheet

Hello IAN M and welcome to the forum !
Open your spreadsheet and press alt+F11
in the left hand side locate your workbook name then locate below Thisworkbook and double click the same a window will open then copy paste below
and save workbook as macro enabled book

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

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

Open the attachment press Alt+F11
left hand side locate VBA Project(Protect.xlsm) below find thisworkbook double click and you will see the code

to copy same in your workbook
left hand side locate VBA Project(your workbook name ) below find thisworkbook double click and copy paste the same code
save your workbook as macro enabled book

click " * " add reputation icon if above helps you