Hello,
I am working with Excel 2003. Though I have learned how I came about this error, I cannot seem to find a way to fix it.
I begin working in Visual Basic on one computer, then did some work on the document on another computer which runs on Microsoft Office 2010. Upon returning to work on this document in Microsoft Office 2003, many of the Libraries--> Class--> Members appear as partially hidden and do not work as they once did when I try to manually type them into the code.
For example, to prompt a userform to Hide when a command button done3 is clicked in a userform:This .Hide is a Member of the Class "DialogSheet" which now appears as a hidden line in my object browser, as seen in this image:![]()
Private Sub done3_Click() userform1.Hide End Sub
example.jpg
I have re-installed all Visual Basic related programs in an attempt to reset anything that might have been corrupted with no avail. Is this issue instead directly related to the Excel file itself instead of Visual Basic?
Please let me know if there is additional information needed to help shed some light on this issue.
Thank you very much![]()
Bookmarks