Help with Excel Add-in
 

Are you building a toolbar or adding something to the menubar?

If you are...

I think your life will be lots easier if you create that toolbar when the
workbook opens and destroy it when the workbook closes.

Some references if you want to look at that option:

For additions 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)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.


FJ wrote:

Hi, I'm very new to VBA and I'm trying to create an add-in. The problem is,
after I've created it, I can't seem to load it correctly so that the macros
will be available to other workbooks. I have read several pages of step by
step instructions online that are very good and very detailed, but in the
end, I still can't seem to get it to work. Ive done the following:

- Created the add-in.
- Renamed the VBAProject in the properties window.
- Saved the add-in in c:\documents and settings\John Doe\Application
Data\Microsoft\AddIns.
- Set the reference to the add-in from the Tools, References box in the VB
editor.
- Made sure the box is checked in Tools, Add-Ins on the Excel worksheet.

I'm probably missing something very obvious, but since VBA is all very new
to me, I'm not sure what.

Thanks in advance for any help or advice.

P.S., sorry if this is a duplicate post. I tried to post a while ago and
got an error message. Not sure if it went through twice.

--

Dave Peterson

Help with Excel Add-in
 

Hi, Dave, I'm trying to add a button to run a macro. This isn't for anything
important right now. I'm just trying to learn how to do it.

Thank you very much for the links. They seem to have a lot of good
information and I will definitely read through them all later. :)





"Dave Peterson" wrote:

Are you building a toolbar or adding something to the menubar?

If you are...

I think your life will be lots easier if you create that toolbar when the
workbook opens and destroy it when the workbook closes.

Some references if you want to look at that option:

For additions 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)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.


FJ wrote:

Hi, I'm very new to VBA and I'm trying to create an add-in. The problem is,
after I've created it, I can't seem to load it correctly so that the macros
will be available to other workbooks. I have read several pages of step by
step instructions online that are very good and very detailed, but in the
end, I still can't seem to get it to work. I€„¢ve done the following:

- Created the add-in.
- Renamed the VBAProject in the properties window.
- Saved the add-in in c:\documents and settings\John Doe\Application
Data\Microsoft\AddIns.
- Set the reference to the add-in from the Tools, References box in the VB
editor.
- Made sure the box is checked in Tools, Add-Ins on the Excel worksheet.

I'm probably missing something very obvious, but since VBA is all very new
to me, I'm not sure what.

Thanks in advance for any help or advice.

P.S., sorry if this is a duplicate post. I tried to post a while ago and
got an error message. Not sure if it went through twice.

--

Dave Peterson

Help with Excel Add-in
 

Hi, Dave, I just wanted to let you know that I finally had a chance to read
through some of the material on the links you posted and it's really great.
Thanks for posting those. I followed Debra Dalgleish's instructions and was
able to get a toolbar.

I obviously have a lot to learn about macros, toolbars, buttons, etc. but
after all the valuable information everyone here has given me, things are
becoming much clearer.

Thanks again! :)




"Dave Peterson" wrote:

Are you building a toolbar or adding something to the menubar?

If you are...

I think your life will be lots easier if you create that toolbar when the
workbook opens and destroy it when the workbook closes.

Some references if you want to look at that option:

For additions 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)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.


FJ wrote:

Hi, I'm very new to VBA and I'm trying to create an add-in. The problem is,
after I've created it, I can't seem to load it correctly so that the macros
will be available to other workbooks. I have read several pages of step by
step instructions online that are very good and very detailed, but in the
end, I still can't seem to get it to work. I€„¢ve done the following:

- Created the add-in.
- Renamed the VBAProject in the properties window.
- Saved the add-in in c:\documents and settings\John Doe\Application
Data\Microsoft\AddIns.
- Set the reference to the add-in from the Tools, References box in the VB
editor.
- Made sure the box is checked in Tools, Add-Ins on the Excel worksheet.

I'm probably missing something very obvious, but since VBA is all very new
to me, I'm not sure what.

Thanks in advance for any help or advice.

P.S., sorry if this is a duplicate post. I tried to post a while ago and
got an error message. Not sure if it went through twice.

--

Dave Peterson