[mso] Re: XL2K Auto_Load Toolbar button

I'll play with it Friday, but I think that is what I want... will let you
know

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Linda F. Johnson
Sent: Wednesday, January 22, 2003 11:43 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: XL2K Auto_Load Toolbar button



I guess I'm not understanding what you want to do, April.  If all you want
is for that macro to be available just in that file, just record the macro
INSIDE that file and in the first box that comes up, tell it to store it in
"This workbook"...then assign it to a toolbar thru Tools>Customize....then
it will only be on the toolbar when that workbook is open.

Is that what you want?

Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm



-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of April Pace
Sent: Monday, January 20, 2003 2:17 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] XL2K Auto_Load Toolbar button



WOW, what a busy weekend... I am resending this because I'm not sure if it
went through



Can I create a macro, that when a particular file is open that a Toolbar
button is added (it is linked to another macro) to the toolbar and removed
then the file is closed.


I tried recording the steps to create the button, name it, and assigned it
to the macro "EnterGrades"  This is all it recorded:

Sub Auto_load()
'
' Auto_load Macro
' Macro recorded 1/16/2003 by  April Pace
'

'
    Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton, _
        ID:=2950, Before:=22
End Sub


How do I get it to also, add the text (always and only show) "Enter Grades"
and assign it to the macro "EnterGrade"?

April



*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: