macro = Can't perform requested requested operation

[John]

I was editing a macro. Suddenly said the "Can't perform etc." when tried
to run it in the editor. Backed out without saving and closed
everything. Opened... and it won't run or step into without the same
message.

If I click the button on the spreadsheet to run it it says it can't find
the macro. The macro is listed in the macro section along with other
macros. When I choose this particular macro the run is blanked out.

Baffling... what do I do now?
Thanks
John

 

[Internetdomainowner]

I was editing a macro. Suddenly said the "Can't perform etc." when tried
to run it in the editor. Backed out without saving and closed
everything. Opened... and it won't run or step into without the same
message.

If I click the button on the spreadsheet to run it it says it can't find
the macro. The macro is listed in the macro section along with other
macros. When I choose this particular macro the run is blanked out.

Baffling... what do I do now?
Thanks
John

I'd recommend the following...

Export the modules and insert the code into a new workbook.

or you can try...

http://www.appspro.com/Utilities/CodeCleaner.htm

~ Cheers ~

 

[John]

I can't export it because I can't get into it. Excel says it can't find
it even though it is listed under macros.
John

 

[John]

Office 2003 excel. I was debugging the macro. It had run, found an error
and I had added some code forgetting to reset the run. From what I've
read (which is very little) that caused the problem. From then on the
macro was grayed out in the macro list. If I tried to step into it it
said excel couldn't find it.

I couldn't get into the macro because it was grayed out. I solved this
by opening all the other macros. Then I could page through and found the
offending macro. It still reported the same error and I couldn't get it
to run. So I copied it. Opened a new macro, pasted to that and named it
something else. Then I deleted the old macro and everything seems to be
fine now.

I guess the lesson is to reset the run in the macro editor before adding
code.

I'm surprised I couldn't find any help, suggestions or other instances
of this using google or Microsoft. I must be truly unlucky.

JOhn

 

[naksndshuerh]

I also had the error message "Can't perform requested operation".

Creating a new Excel document and importing all code files (which we had previously exported) fixed the problem for me. Tedious work to import files again but after several hours of troubleshooting this was the only way for me to get this working again.

I created a user in this forum just to confirm that this solved my problem.

 

[scooby4791]

Same here, but in Solidworks 2016 vba ide. Had to do the same export then import into a new macro.