View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Douglas Klimesh Douglas Klimesh is offline
external usenet poster
 
Posts: 10
Default macro = Can't perform requested requested operation

What version of Excel are you running and what kind of things was the
macro doing?

I've recently been automatically creating instances of Excel and
sometimes when the code in development fails to close them some do not
appear and become orphaned ghosts and only show up in the process list
on Task Manager. A reboot clears them.

John wrote:
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

wrote:
On Jul 23, 10:43 am, John wrote:
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 ~