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). //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). //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 *************************************************************