Link to home
Start Free TrialLog in
Avatar of CraigStenton
CraigStenton

asked on

Excel 97 on Vista - unable to record macro

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".
Avatar of squirrel_force
squirrel_force

97 Office doesnt work on Vista thats the problem.

The version atleast you need is 2003 for full support.
Check allow macros in your Macro Security settings
ASKER CERTIFIED SOLUTION
Avatar of Danny Child
Danny Child
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial