Go to the VBIDE (Alt-F11), open the immediate window (Ctrl-G) and type
Application.Commandbars(1).Enabled = True
and Enter
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
quot;wbezquot; gt; wrote in message
...
gt;
Thanks, work like a bomb.
quot;Bob Phillipsquot; wrote:
gt; Go to the VBIDE (Alt-F11), open the immediate window (Ctrl-G) and type
gt;
gt; Application.Commandbars(1).Enabled = True
gt;
gt; and Enter
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;wbezquot; gt; wrote in message
gt; ...
gt; gt;
gt;
gt;
gt;
What, you mean it blew your PC up. Sorry lt;vbggt;
Bob
quot;wbezquot; gt; wrote in message
...
gt; Thanks, work like a bomb.
gt;
Thanks bob, after 2 hours of frustration, that worked like a dream! GT
quot;Bob Phillipsquot; wrote:
gt; Go to the VBIDE (Alt-F11), open the immediate window (Ctrl-G) and type
gt;
gt; Application.Commandbars(1).Enabled = True
gt;
gt; and Enter
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;wbezquot; gt; wrote in message
gt; ...
gt; gt;
gt;
gt;
gt;
- Jun 04 Wed 2008 20:44
How do I find the Worksheet Menu bar in Excel if that is missing?
close
全站熱搜
留言列表
發表留言
留言列表

