Excel macro not working with shortcut

[creeker69]

Hi,
I have an Excel 2000 worksheet (on windows2000) that I have been using for two years. I have a macro that I recorded that prints the worksheet and clears the data to make it ready for another set of calculations.

When i open the worksheet, it still prompts me to enable macros, which I do. But, it not no longer runs with the keyboard shortcut (ctrl+shift+z). It will however run if I hit ALT+F8 and select the macro and 'run' it. Doing that it still works fine but the keyboard shortcut is no longer working. I opened TOOLS,MACROS,OPTIONS, and the macro still has the shortcut listed as ctrl+shift+z. I clicked out 'okaying' every step of the way but still no keyboard shortcut. Any ideas what happened to it?????

Thanks,
creeker69

 

[jfhewitt]

Why not just assign the macro to a toolbar button? Easiest way.