display settings

M

Mark

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
 
T

Tom Ogilvy

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

Vasant Nanavati

Probably the easiest and safest way is:

Application.DisplayFullScreen = True
Application.CommandBars(1).Enabled = False

and then change it back on exit.
 
M

Mark

Hi Tom!
I meant about using VBA to hide Excel Menus and
commandbars and before close workbook restore old personal
setting each user.
Regards
Mark
 
M

Mark

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
 
Top