blank worksheet menu bar on top

K

kemal

Hi

I disable worksheet menu bar on opening workbook and do things via
controls on sheets.
But on some sheets a blank menu bar reappears on top blocking top
rows.
To get rid of it I run below

Application.CommandBars("Standard").Visible = True
Application.CommandBars("Standard").Visible = False

Now things go well. I searched all postings regarding this issue and
found no answer.
Has anyone faced this problem ? If so what are their solutions I'd
like to know.

Thanks in advance
 

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

Similar Threads

Use VBA to change &File Control in Worksheet Menu Bar 0
Workbook_open not executing 3
hide formula bar (and menu bar etc) 2
Workbook_close 1
hide menu bar 1
auto enable macros 5
List Visible Controls in CommandBars("Worksheet Menu Bar") 3
MAJOR PROBLEM! --- Menu Bars don't unhide? 9

Top