PC Review


Reply
Thread Tools Rate Thread

addin toolbar

 
 
=?Utf-8?B?Z3VlZGo1NA==?=
Guest
Posts: n/a
 
      9th Nov 2006
Hi,
I have a macro called Mymacro()
I need to save that macro as an add-in...

The problem is that I need to have a toolbar button that will launch
Mymacro().

I need the addid to create this toolbar button too.

Any idea?

Paul
 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      9th Nov 2006
See this page for a example
http://www.contextures.com/xlToolbar02.html

--
Regards Ron de Bruin
http://www.rondebruin.nl



"guedj54" <(E-Mail Removed)> wrote in message news:9C180CDA-3C10-42C7-8299-(E-Mail Removed)...
> Hi,
> I have a macro called Mymacro()
> I need to save that macro as an add-in...
>
> The problem is that I need to have a toolbar button that will launch
> Mymacro().
>
> I need the addid to create this toolbar button too.
>
> Any idea?
>
> Paul



 
Reply With Quote
 
=?Utf-8?B?Q2FybG9z?=
Guest
Posts: n/a
 
      9th Nov 2006
Hi,

I had the same problem too and decided to assign shortcut keys to my macros.
This way I sepparated the issue of the macro that launches the toolbar from
the macros that do the tasks. For example, you could install the Add-Inn and
have the following code in one module

Option Explicit
Public Sub SetMacroOptions()
Dim Description As String
Description = "Installs the ""error checking"" and ""show/hide"" command bars"
Call Application.MacroOptions(Macro:="InstallCommandBar", _
Description:=Description, _
HasShortcutKey:=True, _
ShortcutKey:="I")
End Sub

After you put the Add-Inn in the right folder, you just press Ctrl+Shift+I
and the toolar is installed (the "InstallCommandBar" macro). I hope this
helps.

What do you mean when you say "I need to save that macro as an Add-In"? Do
you mean saving a workbook (that contains VB code) as an Add-In?

--
Carlos


"guedj54" wrote:

> Hi,
> I have a macro called Mymacro()
> I need to save that macro as an add-in...
>
> The problem is that I need to have a toolbar button that will launch
> Mymacro().
>
> I need the addid to create this toolbar button too.
>
> Any idea?
>
> Paul

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: xlb size and addin with custom toolbar Gord Dibben Microsoft Excel Programming 1 23rd Oct 2008 02:08 PM
where is the addin section of the toolbar =?Utf-8?B?SWFpbiBNYXJ0aW4=?= Microsoft Word Document Management 3 16th Feb 2007 04:49 PM
Re: toolbar addin for tabs Dave Peterson Microsoft Excel Misc 0 1st Dec 2006 02:28 AM
Re: toolbar addin for tabs Gord Dibben Microsoft Excel Misc 0 30th Nov 2006 11:47 PM
How do I Add an Addin to Toolbar Xispo Microsoft Excel Programming 1 12th Nov 2003 09:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:10 AM.