Menu Toolbar

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

I have a macro that is executed by clicking on Tools/PrintSheet on the Menu
Bar for a particular workbook. I'm trying to change the name for PrintSheet
to something else, but the change always go back to the way it was, when I
open the workbook again. I'm using Excel 2002

Can someone explain how this is done?

Thanks,
Bernie
 
Is PrintSheet a custom menu item, created by one of your workbooks? If so,
you need to get at the code that creates it.
 
Yes, PrintSheet is a custom menu item, but it is not created by one of the
workbooks. I can change the name via the custom menu for the current
session, but it is not available to attach to the workbook, and saving my
workbook does not save the new PrintSheet name as I have changed it.

Bernie
 
Bernie,

You may have and add-in that creates it.

Take a look at Tools>Add-ins... and try unchecking any checked items and
re-starting Excel, one by one, until you find it. Make a note of which you
uncheck though so that you can revert.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top