display settings
 

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

display settings
 

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

display settings
 

Probably the easiest and safest way is:

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

and then change it back on exit.

--

Vasant




"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

display settings
 

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


-----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


.

display settings
 

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


.