Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 87
Default Can't perform requested operation in excel macro

Programing a macro in excel 2003. At some point I got "Can't perform
requested operation" when trying to run it. So I saved the whole thing
and went to bed.

Now excel won't run the macro at all. If I just try "Step into" I get
the same error, "Can't perform the requested operation." It won't let me
open it with edit either. Same error.


How do I get back into the macro to edit it and fix whatever is wrong?

John
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Can't perform requested operation in excel macro

John,
Disable macros when you open the file.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"John"
wrote in message
Programing a macro in excel 2003. At some point I got "Can't perform
requested operation" when trying to run it. So I saved the whole thing
and went to bed.

Now excel won't run the macro at all. If I just try "Step into" I get
the same error, "Can't perform the requested operation." It won't let me
open it with edit either. Same error.
How do I get back into the macro to edit it and fix whatever is wrong?
John
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default Can't perform requested operation in excel macro

try in excel :

tools - macro - security - security level - low
and then ok ; maybe help
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a function to perform this operation? Ayo Excel Discussion (Misc queries) 2 July 17th 09 03:17 AM
Excel 2007 - Macro to do a simple cut/paste operation. Grindy Excel Discussion (Misc queries) 2 January 26th 09 01:11 AM
Connection Cannot Be Used to Perform this Operation alexcn Excel Programming 0 May 8th 07 07:13 PM
Complex Macro to perform an operation as it steps down cells? Jeni Q Excel Worksheet Functions 0 August 25th 05 04:38 PM
microsoft outlook unable to perform operation - send = receive. heibner Excel Discussion (Misc queries) 1 July 13th 05 09:05 AM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"