C
Celtic_Avenger
Hi Folks.........I really really hope someone can help with this.
I have quite a large spreadsheet with many many user ineractive pages
and user forms as menus. Since I dont want the users to be able t
access the menu bars I have turned them off, with the following code
in the "This Workbook" VBA page.
Application.CommandBars.ActiveMenuBar.Enabled = False
Application.DisplayFormulaBar = False
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Formatting").Visible = False
And all the other CommandBars as well to many to need to list here.
However on the sheets that my users do get direct access to, there is
grey box and a grey line, what look like the background colours to
commmand bar sitting over the top of the cells at the top of the page
They dont look like a blank Commandbar, just a thick grey line wher
one would be. This stops my users from seeing or using the top cells.
Is there a way of getting rid of these...........I have tries man
variations of the screenupdate command, but no joy.
This is really annoying.
Can anyone help?
Thanks
Celtic_Avenger
:mad
I have quite a large spreadsheet with many many user ineractive pages
and user forms as menus. Since I dont want the users to be able t
access the menu bars I have turned them off, with the following code
in the "This Workbook" VBA page.
Application.CommandBars.ActiveMenuBar.Enabled = False
Application.DisplayFormulaBar = False
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Formatting").Visible = False
And all the other CommandBars as well to many to need to list here.
However on the sheets that my users do get direct access to, there is
grey box and a grey line, what look like the background colours to
commmand bar sitting over the top of the cells at the top of the page
They dont look like a blank Commandbar, just a thick grey line wher
one would be. This stops my users from seeing or using the top cells.
Is there a way of getting rid of these...........I have tries man
variations of the screenupdate command, but no joy.
This is really annoying.
Can anyone help?
Thanks
Celtic_Avenger
:mad