Thick Grey Line Where ActiveMenuBar Used To Be....HELP!

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: :confused: :mad: :confused: :mad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top