Posted by Angela on April 27, 2001 7:18 AM
I have several users who are getting the error message "failed to register the visual basic environment" when opening spreadsheets with macros. I have added and removed the analysis toolpak and analysis toolpak-vba add-ins on my PC and on two of the problem PCs without resolving the issue. I (administrator)logged into my PC as a regular user and opened the files without any errors. One of those users can log into his local machine as the administrator and is able to open the problem files. I logged into one the other PC as the administrator and was unable to open the files. I have tried everything I can think of and I have been unable to isolate the problem. I even reinstalled MS Office 97. If it makes a difference, we do use SMS to install most of our applications. HELP!!!