PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Can not execute a macro with a toolbar button

Reply

Can not execute a macro with a toolbar button

 
Thread Tools Rate Thread
Old 30-06-2003, 08:55 PM   #1
Lori
Guest
 
Posts: n/a
Default Can not execute a macro with a toolbar button


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!

  Reply With Quote
Old 01-07-2003, 02:16 AM   #2
Dave Peterson
Guest
 
Posts: n/a
Default Re: Can not execute a macro with a toolbar button

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/groups?threadm=06...1280a%40phx.gbl

Lori wrote:
>
> 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
ec35720@msn.com
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off