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.

Why dont you build an excel Add-In?

For help Refer
http://www.fontstuff.com/VBA/vbatut03.htm

If this post helps click Yes
---------------
Jacob Skaria


"gigabyteconsulting" wrote:

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.

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.

"Jacob Skaria" wrote:

Why dont you build an excel Add-In?

For help Refer
http://www.fontstuff.com/VBA/vbatut03.htm

If this post helps click Yes
---------------
Jacob Skaria


"gigabyteconsulting" wrote:

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.

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

gigabyteconsulting wrote:

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.

"Jacob Skaria" wrote:

Why dont you build an excel Add-In?

For help Refer
http://www.fontstuff.com/VBA/vbatut03.htm

If this post helps click Yes
---------------
Jacob Skaria


"gigabyteconsulting" wrote:

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.

--

Dave Peterson

Thank you

"Dave Peterson" wrote:

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

gigabyteconsulting wrote:

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.

"Jacob Skaria" wrote:

Why dont you build an excel Add-In?

For help Refer
http://www.fontstuff.com/VBA/vbatut03.htm

If this post helps click Yes
---------------
Jacob Skaria


"gigabyteconsulting" wrote:

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.

--

Dave Peterson