K
kcammandc
hi
i have a database running in excel, and i have a main control
worksheets, but i want to hide certain elements. i can run this code,
but the last line fails. any ideas would be good.
Sub Auto_open()
ActiveWindow.DisplayWorkbookTabs = False
Application.DisplayScrollBars = False
Application.DisplayFormulaBar = False
Application.CommandBars("standard").Visible = False
Application.CommandBars("formatting").Visible = False
Application.CommandBars("Worksheet Menu Bar").Visible = False
yours
Eliot
IT Trainer
i have a database running in excel, and i have a main control
worksheets, but i want to hide certain elements. i can run this code,
but the last line fails. any ideas would be good.
Sub Auto_open()
ActiveWindow.DisplayWorkbookTabs = False
Application.DisplayScrollBars = False
Application.DisplayFormulaBar = False
Application.CommandBars("standard").Visible = False
Application.CommandBars("formatting").Visible = False
Application.CommandBars("Worksheet Menu Bar").Visible = False
yours
Eliot
IT Trainer