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

Thanks for assistance!! I followed instruction but got message "Compile Error: Ambiguous name detected: Workbook_BeforeClose

Spreadsheet is already macro enabled with

Sub ProtectALLShts()
Dim Pwd
Pwd = "Clyde123"
For Each ws In Sheets
If ws.ProtectContents = False Then
ws.Protect Password:=Pwd
End If
Next
ActiveWorkbook.Save
End Sub

as well as

Sub UnProtectAll()
Dim wSheet As Worksheet
Dim Pwd As String
Pwd = InputBox("Enter your password to unprotect all worksheets", "Password Input")
On Error Resume Next
For Each wSheet In Worksheets
wSheet.Unprotect Password:=Pwd
Next wSheet
If Err <> 0 Then
MsgBox "You have entered an incorrect password. All worksheets could not " & _
"be unprotected.", vbCritical, "Incorrect Password"
End If
On Error GoTo 0
End Sub

Perhaps this is confusing the issue?

Thanks/Dankie Winon

Ian

that means you have two subroutines named Workbook_beforeclose
Copy the code lines from Hemesh's Workbook_before close and incorporate them into the already existing routine

Hello Ian M,

Welcome to the Forum.

Moderation requests removed, as OP has reponded to same.

Hello find the attached ! There is no problem here ! After adding your code ! As per the litch you had two WBK_Open subs
Didn't See your file at first !

Hello Ian M,

Dankie vir die samewerking.

I think AndyLitch, and hemesh managed to clear things up for you, by spotting where you went wrong with your VBA.

If your issue has been sorted out, then please mark your thread as Solved, or do you have some other issues remaining?

Regards

Hunting . . . how do I mark as solved?

. . . . . . read the rules!! (Proving I am a normal male - read the rules only after trying first!)

LOL!

. . . read the rules!! (Proving I am a normal male - read the rules only after trying first!)

Typical. Applies to me as well!

Thank you for catching up so fast.

Groete.