Macro removed incorrectly - still shows in macro list!

Posted by Martin Nielson on October 21, 2000 8:26 PM

I had a macro that I cut out of a module and pasted it elsewhere in the same project. Then I decided to use it as a command button click event SUB instead. My spreadsheet works until I PROTECT the worksheet...then as soon as a click is made on the spreadsheet I get error "....macro cannot be found". The macro still shows in the macro list Tools/Macros, but because it doesn't exist...I'm not given the option of deleteing it.

Posted by cher on October 22, 2000 5:14 AM

Print odd page numbering?

Anyone know how to print odd page number?

vba or header footer trick or tip.

thanks Cher

Posted by Christopher Mains on October 24, 2000 9:49 AM

I had a similar problem, where I had moved my macros into the actual sheets code. When you move any macro you will need to reassign the macro to the object. Try reassigning it. If you have anyother problems feel free to email me.
Christopher