?
Solved

Excel 97 on Vista - unable to record macro

Posted on 2009-05-11
6
Medium Priority
?
623 Views
Last Modified: 2012-05-06
I have installed Office Pro 97 on a Vista machine, but cannot record a macro in either Word or Excel.  Thinking it might be a problem with references I tried to check but cannot get into references - it is greyed out.
When I try to record a macro I get "unable to record".
0
Comment
Question by:CraigStenton
5 Comments
 

Expert Comment

by:squirrel_force
ID: 24353204
97 Office doesnt work on Vista thats the problem.

The version atleast you need is 2003 for full support.
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24353207
Check allow macros in your Macro Security settings
0
 
LVL 23

Accepted Solution

by:
Danny Child earned 500 total points
ID: 24353646
workaround here:
http://forums.techguy.org/business-applications/674573-excel-97-unable-record-macro.html
at the end

"open a worksheet I had created while I was using Windows XP (and in which I still could record macros), delete its contents and existing macros so that it was totally empty, then save the worksheet as a template, which I named OKmacro.

From now on if I wish to create a worksheet and record macros I can simply open the template. "
Kudos to Cullism of that site if it works...
0
 
LVL 23

Expert Comment

by:Danny Child
ID: 24353719
But you should be aware that Excel 97 stopped having support, ie patches on 16/1/04

So, you're at risk using it from all kinds of nasties, bugs, flaws and so on.  
http://support.microsoft.com/lifecycle/?p1=1757

and full list
http://support.microsoft.com/gp/lifeselectoff

Me, I'd upgrade in a heartbeat.  You can get a 60 day trial download of Office 2007
http://office.microsoft.com/en-gb/products/HA101741481033.aspx
0
 
LVL 14

Assisted Solution

by:Geisrud
Geisrud earned 500 total points
ID: 24359344
True enough that Office 97 isn't supported on Vista, or by Microsoft at this point.  However, it does work on Vista - I have it on my machine.  Running macros.

One thing I noticed is that when you go to record it, I got the same error as you when I didn't give it a shortcut key.  As soon as I did, it when right into recording...
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question