close


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;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()