file edit view insert etc disable

[pswanie]

what code if possible would disable the file edit view etc at the top of my
excel sheet? and if posible the litle red 'x' in the right top corner? and
then enable that again at save and close?

 

[shah shailesh]

To hide worksheet menu bar use,

CommandBars("worksheet menu bar").Enabled = false

to make unhide

CommandBars("worksheet menu bar").Enabled = true

and if posible the litle red 'x' in the right top corner? and
then enable that again at save and close?

Record macro for Protect workbook with windows tickmarked.
Tools>Protect Workbook>

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.