close

Hi!

I just managed to create an Add-in on our server that shows up fine on
my workstation. The macro is not available though. I can see it and run
it in VBE, but it's not listed under Run --gt; Macro.

Please advice!

Martin--
mliungman
------------------------------------------------------------------------
mliungman's Profile: www.excelforum.com/member.php...oamp;userid=30397
View this thread: www.excelforum.com/showthread...hreadid=501594It doesn't show, but you can still run it by typing it in the textbox

myAddin.xla!MySub

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;mliungmanquot; gt; wrote
in message ...
gt;
gt; Hi!
gt;
gt; I just managed to create an Add-in on our server that shows up fine on
gt; my workstation. The macro is not available though. I can see it and run
gt; it in VBE, but it's not listed under Run --gt; Macro.
gt;
gt; Please advice!
gt;
gt; Martin
gt;
gt;
gt; --
gt; mliungman
gt; ------------------------------------------------------------------------
gt; mliungman's Profile:
www.excelforum.com/member.php...oamp;userid=30397
gt; View this thread: www.excelforum.com/showthread...hreadid=501594
gt;
BTW, functions will show in the function list.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;mliungmanquot; gt; wrote
in message ...
gt;
gt; Hi!
gt;
gt; I just managed to create an Add-in on our server that shows up fine on
gt; my workstation. The macro is not available though. I can see it and run
gt; it in VBE, but it's not listed under Run --gt; Macro.
gt;
gt; Please advice!
gt;
gt; Martin
gt;
gt;
gt; --
gt; mliungman
gt; ------------------------------------------------------------------------
gt; mliungman's Profile:
www.excelforum.com/member.php...oamp;userid=30397
gt; View this thread: www.excelforum.com/showthread...hreadid=501594
gt;
Give the user a way to run your macro.

If you want to add an option to the worksheet menu bar, I really like the way
John Walkenbach does it in his menumaker workbook:
j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)
mliungman wrote:
gt;
gt; Hi!
gt;
gt; I just managed to create an Add-in on our server that shows up fine on
gt; my workstation. The macro is not available though. I can see it and run
gt; it in VBE, but it's not listed under Run --gt; Macro.
gt;
gt; Please advice!
gt;
gt; Martin
gt;
gt; --
gt; mliungman
gt; ------------------------------------------------------------------------
gt; mliungman's Profile: www.excelforum.com/member.php...oamp;userid=30397
gt; View this thread: www.excelforum.com/showthread...hreadid=501594

--

Dave Peterson


Thanks guys!

You gave several answers to my first question, and the second solved
itself. I was having computer problems, not VBA problems.

Martin--
mliungman
------------------------------------------------------------------------
mliungman's Profile: www.excelforum.com/member.php...oamp;userid=30397
View this thread: www.excelforum.com/showthread...hreadid=501594

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

    software

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