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
- May 16 Wed 2007 20:37
How to make an Add-in show under Run-gt;Macro
close
全站熱搜
留言列表
發表留言