Excel Issue - MISSING: Ref Edit Control
This is a long issue I will try to make short and I would appreciate some suggestion on a "Best Practice" for this.
Background:
At my office we are upgrading groups of users from Office 2003 sp2 to Office 2007. My End-Users are all Actuary's and are all very advanced Excel, VBA users.
Issue:
If a Module/workbook is opened /saved in 2007 (as a .xls) that contains a user form it will add a reference to the "RefEdit Control", but functionally everything is still fine. If this same file is then opened in 2003 sp2 you will receive a "Cannot find project or library error".
So far anytime we've had to send a deliverable to a client I just have the End-User uncheck the RefEdit Control reference.. Does anyone have any ideas of a better way? We don't use RefEdit on any of our user forms.
Background:
At my office we are upgrading groups of users from Office 2003 sp2 to Office 2007. My End-Users are all Actuary's and are all very advanced Excel, VBA users.
Issue:
If a Module/workbook is opened /saved in 2007 (as a .xls) that contains a user form it will add a reference to the "RefEdit Control", but functionally everything is still fine. If this same file is then opened in 2003 sp2 you will receive a "Cannot find project or library error".
So far anytime we've had to send a deliverable to a client I just have the End-User uncheck the RefEdit Control reference.. Does anyone have any ideas of a better way? We don't use RefEdit on any of our user forms.
Last Comment
ASKER
I just looked through the file again and I can't find RefEdit being used, and I talked with the user who updates the model and he isn't familiar with RefEdit being used either. You are right though I've looked at other worksheets containing user forms and it doesn't create a reference to RefEdit Control. So there has to be something with this one Models, but it just happens to be one of the biggest and most used.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Zorvek Thanks for the help, I haven't been able to pinpoint why RefEdit is being flagged, but my endusers here will have to step through it.
ASKER
Thanks again for the help
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Kevin