using windows XP professional and excel 200
S swatsp0p Sep 21, 2004 #2 Place the button on your sheet. Right Click on the button and select "View Code". This opens the VB editor to the module for the button. Enter your macro here. If you have recorded a macro elsewhere, cut and paste works well, too.
Place the button on your sheet. Right Click on the button and select "View Code". This opens the VB editor to the module for the button. Enter your macro here. If you have recorded a macro elsewhere, cut and paste works well, too.
S swatsp0p Sep 21, 2004 #3 sorry, missed the part about the "Menu". This is for a "command" button in a spreadsheet.
D Dave Peterson Sep 21, 2004 #4 Is this for lots of macros--maybe your personal.xls. John Walkenbach has a very nice menumaker workbook that adds an option to the worksheet menubar. It looks very nice and is easy to update. http://j-walk.com/ss/excel/tips/tip53.htm
Is this for lots of macros--maybe your personal.xls. John Walkenbach has a very nice menumaker workbook that adds an option to the worksheet menubar. It looks very nice and is easy to update. http://j-walk.com/ss/excel/tips/tip53.htm
