Can not execute a macro with a toolbar button

[Lori]

I support a customer base for MS office training. I know
Excel basics, and have tried to research an issue for a
client, but have not been able to resolve her issue.
Following is an excerpt from her email to me:

"It is not a macro issue, it is a toolbar issue. My
macros work fine. My excel toolbar(s) are read-only. I
can not change my toolbar(s) - well I can change them, but
the changes will be gone the next time I open excel (gone
because the toolbar is readonly). I can't save changes to
a readonly toolbar).

The readonly toolbar is a problem when I try to access
macros buttons on my toolbar - my macro buttons are gone
the next time I open excel because my toolbar is
readonly. Thus, I can not execute a macro with a toolbar
button. I have to execute my macros by assigning them to
a keyboard stroke. Excel will only allow macros to be
placed on letter keys - I ran out of letter keys. I need
to be able to assign macros to toolbars, I need my toolbar
to have write ability."

I sincerely appreciate your help, if anyone has
experienced this type of situation and can shed some
light... Thanks in advance!

 

[Dave Peterson]

How are you building your toolbar? Is it attached to a workbook or do you build
it each time you open the workbook?

If it's attached manually (tools|macros), then you may want to read a few notes
that Jan Karel Pieterse wrote:

http://google.com/[email protected]