Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I currently use similar code to the following to control what the user sees
when working with Excel tools I have created for my company. These settings occur on Auto_Open. I then reverse these settings when the user closes the workbook down. Is there a quicker way of controlling the user environment, and if so, how do I do this? With ActiveWindow .DisplayGridlines = False .DisplayHeadings = False .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = True .DisplayWorkbookTabs = False .DisplayZeros = False Application.DisplayFullScreen = False Application.DisplayFormulaBar = False Application.DisplayStatusBar = False Application.CommandBars("Drawing").Visible = False Application.CommandBars("Standard").Visible = True Application.CommandBars("Formatting").Visible = False Application.CommandBars("Reviewing").Visible = False Application.CommandBars("Web").Visible = False End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Controlling an Option Group in a User Form | Excel Discussion (Misc queries) | |||
Creating and Controlling a User data Entry Sheet | Excel Discussion (Misc queries) | |||
Editing in a multi-user environment | Excel Discussion (Misc queries) | |||
Is it possible to use excel in a multi user environment? | Excel Discussion (Misc queries) | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |