display settings

[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

 

[Tom Ogilvy]

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

 

[Vasant Nanavati]

Probably the easiest and safest way is:

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

and then change it back on exit.

 

[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

 

[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

 

[Tom Ogilvy]

search google groups - this question is asked all the time. There should be
plenty of sample code.

http://groups.google.com/advanced_group_search?hl=en

look for commandbars hide restore

or menus hide restore or leave out restore

group microsoft.public.excel.programming