Excel Recording Macros in Excel 97 with Vista


Joined
Jan 3, 2008
Messages
49
Reaction score
0
I recently tried to record a macro in my old Excel 97. Apparently Excel 97 isn't fully compatible with Vista because I found that whenever I tried I received the message "Unable to record macro". A host of help forums couldn't provide a solution but I found a work-around.

What I did was to open a workbook I had created when I still had Windows XP and which contained macros, clear the worksheet completely, then save the blak work book as a template.

From now on I only need to open the template to create a workbook in which I can record macros.

I submit this semi-solution in the hope that it will be of use to people with the same problem.
 
Ad

Advertisements

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,609
Reaction score
1,324
Thanks Kafka, I'm sure this will help people out with the same problem :thumb:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top