View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How to make an Add-in show under Run-Macro

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:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)



mliungman wrote:

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 -- Macro.

Please advice!

Martin

--
mliungman
------------------------------------------------------------------------
mliungman's Profile: http://www.excelforum.com/member.php...o&userid=30397
View this thread: http://www.excelforum.com/showthread...hreadid=501594


--

Dave Peterson