| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Options - Default Display Settings | Excel Worksheet Functions | |||
| Excel 2007 using control panel display settings | Excel Discussion (Misc queries) | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| New window in Excel does not display default settings | Excel Discussion (Misc queries) | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
![Mark[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
