templates

[evelin via OfficeKB.com]

i have a template with vb macros for creating 3buttons and to do action
depending on button click. in the template i ran the button creating macro so
that those who create files must have the file in that template form. instead
of having to use the macros directly users must be able to click the buttons
in the format and accordinglt it must work. i've tried this but it gets stuck
inbetween. i would like to know
ist is possible or not, if yes, i'll solve the problem

 

[Dave Peterson]

You may find life gets simpler by separating your code from the data in your
workbook template.

You may be able to create a single addin file (tell the users to open it when
they need it!) that does all the work.

But you'll have to give the users a way to run 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

=========================
On the other hand, if you are using buttons from the Forms toolbar placed on a
worksheet, you may find that you can replace those buttons with commandbuttons
from the Control toolbox toolbar.

The code will have to be moved (and slightly modified???). But the code for
these control toolbox toolbar commandbuttons live in the worksheet module that
owns the commandbuttons.

Your macro assignment problem will go away.