Software

Ask something
Discussion Locked

Unable to record macro

0 helpful
2 replies

by pams

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are using a Windows 2000 Server and running Terminal Services via an Internet connection. Office 97 is the installed Office suite. Everything has been working fine until today one of my users tried to record a macro in Excel and they receive the error message: "Unable to record".

Any user who does not have administrative privileges has this problem. If logged on as an administrative user, the procedure works fine. I am inclined to think that this may be a permission or rights issue to a folder or a registry setting because other things have had a similar documented issue.

I have been unable to find the answer on this one, however. Any thoughts on this one would be appreciated.

2 replies

by dklippert

It does appear to be a permission problem. You have a choice of recording the macro for the open Workbook, another Workbook, or the, universal, Personal.xls.
Your user probably can't write to Personal.xls for some reason.
Try setting the recorderto store the macro in "This Workbook"

by pams

The recorder does specify to store the macro in "This Workbook" and they get the "Unable to record" message.

This discussion is closed to new replies.