blank worksheet menu bar on top

kemal@intelinfo.zzn.com

Guest

Posts: n/a

16th Feb 2007

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

« Insert copied row at cursor position | Variant »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA:programmatically invoking menu items from Excel Worksheet menu	=?Utf-8?B?bW9yc2UxMDA=?=	Microsoft Excel Programming	15	29th Oct 2010 07:29 PM
I want a blank space on a worksheet when the question is blank?	=?Utf-8?B?UGF0cml6aWE=?=	Microsoft Excel Misc	2	23rd Jun 2005 12:51 AM
Copying and pasting a worksheet to a blank and removing blank rows	Bob Reynolds	Microsoft Excel Programming	0	24th Jun 2004 02:55 PM
Re: Help! I have 14 pages in a worksheet, pages 8-14 are blank and print that way. How can I delete only the blank pages? I tried delete worksheet and it deleted the whole thing.	Frank Kabel	Microsoft Excel New Users	1	28th Apr 2004 09:20 PM
problem adding button to an EXISTING dropdown menu on a Worksheet Menu Bar	Karen P	Microsoft Excel Worksheet Functions	3	29th Oct 2003 12:42 AM