PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
Can not execute a macro with a toolbar button
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
Can not execute a macro with a toolbar button
![]() |
Can not execute a macro with a toolbar button |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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! |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

