Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro = Can't perform requested requested operation
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro = Can't perform requested requested operation
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 ~ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro = Can't perform requested requested operation
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 ~ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro = Can't perform requested requested operation
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 Douglas Klimesh wrote: 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 ~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Security and Digital signatures - PANIC HELP requested | Excel Discussion (Misc queries) | |||
nique Value Macro requested | Links and Linking in Excel | |||
Can't perform requested operation in excel macro | Excel Programming | |||
Help Requested | Excel Programming | |||
Req: Help requested with Macro problem and syntax errors (any fisherman out there!!) | Excel Programming |