Auto adding a macro when Excel 2003 opens

  • Thread starter gigabyteconsulting
  • Start date
G

gigabyteconsulting

I want to add a macro we created to users machines without having to modify
the book.xlt template. I have noticed that the XLSTART folder does not work
like the STARTUP folder for word. The only way that I have been able to get
this to work is to hide the page in the workbook with the macro, name it to
personal.xls and save it to the xlstart folder. This way the default
template opens and the user can access the macro from the Tools --> Macros
list but the name of the macro is prefaced with personal.xls.
Is this the only way of adding Macros without modifying the base template?
If so is there a way to have Excel not preface the macro name with
personal.xls?
Any help would be appreciated.
 
G

gigabyteconsulting

I created the file as an add-in and added the add-in the first time I opened
a blank woorkbook but when I go into the macros section there is no macro
listed. Not sure why it is not showing.
 
D

Dave Peterson

If you create an addin, then the macros in that addin won't be visible in the
tools|macro|macros dialog.

You'll have to give the users some way of running those macros.

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)

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

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
 
G

gigabyteconsulting

Thank you

Dave Peterson said:
If you create an addin, then the macros in that addin won't be visible in the
tools|macro|macros dialog.

You'll have to give the users some way of running those macros.

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)

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top