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.
ToolsProtect Workbook

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





"pswanie" wrote in message
...
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?