ProteanBeing
02-07-2008, 06:52 AM
I used the following code to hide all command bars, menus and sheet tabs in a workbook to limit the user's interferance:
For Each bar In CommandBars
bar.Enabled = False
Next bar
With ActiveWindow
.DisplayHorizontalScrollBar = False
.DisplayWorkbookTabs = False
.DisplayHeadings = False
End With
Application.DisplayFormulaBar = False
However, Now all of these items are hidden when I open EVERY time I open excel! There is no code in PERSONAL and I have the opposite code in the BeforeClose event of the workbook thinking this would fix the problem. Can anyone help. :help :banghead:
For Each bar In CommandBars
bar.Enabled = False
Next bar
With ActiveWindow
.DisplayHorizontalScrollBar = False
.DisplayWorkbookTabs = False
.DisplayHeadings = False
End With
Application.DisplayFormulaBar = False
However, Now all of these items are hidden when I open EVERY time I open excel! There is no code in PERSONAL and I have the opposite code in the BeforeClose event of the workbook thinking this would fix the problem. Can anyone help. :help :banghead: