Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / July 2003

Tip: Looking for answers? Try searching our database.

Can not execute a macro with a toolbar button

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lori - 30 Jun 2003 20:55 GMT
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 - 01 Jul 2003 02:16 GMT
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=06f901c328ef%24617d6b10%24a301280a%40phx.gbl

> I support a customer base for MS office training.  I know
> Excel basics, and have tried to research an issue for a
[quoted text clipped - 21 lines]
> experienced this type of situation and can shed some
> light...  Thanks in advance!

Signature

Dave Peterson
ec35720@msn.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.