[mso] Re: XL2K Auto_Load Toolbar button
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 22 Jan 2003 11:42:46 -0500
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).
//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:
