Hide Standard Buttons & Stop Work Sheet flashing

Hi I have a spreadsheet I use for work it has to be published as a shared book so various people can use it. I have a couple of issues.

1: Is their anyway I can get rid of the File, Edit, View, etc buttons at the top of the document so everyone that opens it can not see them? and also the save button, the idea is they have to use the button to save the sheet.

2: I have a button on the sheet with a macro that saves the sheet once it has been worked on, the sheet flashes when this button is clicked is there any way I can stop the sheet flashing ?

Good afternoon JimmiOO

Originally Posted by JimmiOO

1: Is their anyway I can get rid of the File, Edit, View, etc buttons at the top of the document so everyone that opens it can not see them? and also the save button, the idea is they have to use the button to save the sheet.

Use this code called from a Workbook_Open event to hide them, and then again from a Workbook_BeforeClose event to reinstate them :

Application.CommandBars("Worksheet Menu Bar").Enabled = False 'Hide toolbar
Application.CommandBars("Worksheet Menu Bar").Enabled = True  'Show toolbar

Originally Posted by JimmiOO

2: I have a button on the sheet with a macro that saves the sheet once it has been worked on, the sheet flashes when this button is clicked is there any way I can stop the sheet flashing ?

Dunno, we'd have to se your code to be sure, but first try disabling screen updating, and restoring it again at the end :

Sub MyMacro()
Application.ScreenUpdating = False

'   Your macro code goes here

Application.ScreenUpdating = True
End Sub

HTH

DominicB