Hi Tom,
I meant using VBA to hide Excel Menus and commandbars,
later when i close workbook i'd like restore personal
settings each user.
Regards.
Mark


-----Original Message-----
Are you talking about the commandbars in the VBE. Or are
you talking about
using VBA to hide Excel Menus and commandbars?

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
I'd like change in VBA display settings (DS) e.g. all
Visible Application.CommandBars and
Application.Display..
(change on false) when i open workbook and DS turn on
when
i close workbook restore personal setting.

Is there any smart code?
I've excel 2k.

Regards
Mark


.