Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have the following code in "This woorkbook"
Private Sub Workbook_Open() Application.CommandBars("Worksheet Menu Bar").Enabled = False Application.CommandBars("Standard").Enabled = False Application.CommandBars("Formatting").Enabled = False Application.CommandBars("Cell").Enabled = False Application.DisplayFormulaBar = False Application.DisplayStatusBar = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.CommandBars("Worksheet Menu Bar").Enabled = True Application.CommandBars("Standard").Enabled = True Application.CommandBars("Formatting").Enabled = True Application.CommandBars("Cell").Enabled = True Application.DisplayFormulaBar = True Application.DisplayStatusBar = True End Sub If the user closes, via the X in the upper right corner, the formula bar and the status bar pops back on the worksheet and stays there if they "cancel". Is it possible to have a change event added to the code to change them back to "False" when any cell is activated. All I need is for them to not be visible long enough to take advantage of them. Thanks Mike Rogers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet Change event | Excel Discussion (Misc queries) | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Excel Automation SelectionChange event | Excel Discussion (Misc queries) | |||
Change of Row event | Excel Discussion (Misc queries) |