LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default unable to record macro

I am using Excel 2003 (SP2 11.8012.6568 running under WinXP SP2) and
get "unable to record" when I try to record a macro in a particular
..xls. Then I can go back into the Tools menu and Stop Recording
(something obviously started). And when I started up VB and try to
look at the module where the new macro would be I get an Excel error
and Excel closes.

However, if I go back into the same .xls and start up VB (Alt-F11)
before recording, I can then record the macro. This is fine as a
workaround but I fear something is corrupted in this .xls that might
manifest itself again later.

By comparison, I have a previous copy of this .xls, before I added a
form and some command buttons, where I can record a macro without
problems.

Any ideas what this might be or whether I should be concerned?

Denis

 
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
UNABLE TO RECORD A MACRO I.C.E. Excel Worksheet Functions 1 September 13th 06 01:24 PM
Unable to record Macro Can not Record Macro Excel Discussion (Misc queries) 1 July 29th 06 01:11 AM
Unable to Record Macro murray Excel Discussion (Misc queries) 1 February 6th 06 04:17 PM
Unable to record macro Pat Excel Discussion (Misc queries) 4 May 20th 05 01:43 AM
Unable to record (macro) JimP Excel Programming 3 July 2nd 04 05:51 PM


All times are GMT +1. The time now is 10:29 AM.

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

About Us

"It's about Microsoft Excel"