I can't launch the VBA editor or record a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(This is my workplace machine. I have no control over what is installed or
omitted.)

Specifically in Excel, when I click on "Tools | Macro | Visual Basic Editor"
the window opens then immediatly closes. When I try to record a macro I get
a message "Unable to Record".
I CAN NOT reproduce this: (I have no workbooks which contain macros anymore)
when I open a workbook which contains macros I get an error "Form20.dll not
found" even tho the file exists.

Is there a way to install Windows 2000, (or is it Office 2000? Excel reports
it is "Excel 97 SR-1") and omit the VBA feature? Can VBA be installed
seperatly?
 
Try asking them here.

http://www.microsoft.com/communitie...52c-645b-4527-8850-1bac042c6bfe&lang=en&cr=US

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| (This is my workplace machine. I have no control over what is installed or
| omitted.)
|
| Specifically in Excel, when I click on "Tools | Macro | Visual Basic
Editor"
| the window opens then immediatly closes. When I try to record a macro I
get
| a message "Unable to Record".
| I CAN NOT reproduce this: (I have no workbooks which contain macros
anymore)
| when I open a workbook which contains macros I get an error "Form20.dll
not
| found" even tho the file exists.
|
| Is there a way to install Windows 2000, (or is it Office 2000? Excel
reports
| it is "Excel 97 SR-1") and omit the VBA feature? Can VBA be installed
| seperatly?
 
No responses, yet.

We "May" be getting a new machine (still a Win 2K but better hardware), this
may fix this problem.
 
Back
Top