Macro help - function to close and save

Good Morning

I hope you are all well.

I am wondering if someone call help me, I have a password protected excel workbook.

I was wondering if there was a function so that I can click the company logo and it will save and close the current worksheet when password has been inputted for editing, but just close the worksheet with no prompt to save as or over ride if opened in read only.

If anyone could help that would great.

Thank you so much for your help in advance.

Have a fantastic day/night (depending where in the world you are)

Thanks

Jodie

Hi jodieduncan,

You can try this code.

If ThisWorkbook.ReadOnly = True Then
    ThisWorkbook.Close
Else
    ThisWorkbook.Save
    ThisWorkbook.Close
End If

Regards,
Sindhu

Thank you Sindhu

Worked a treat.

Much appreciated.