Dear All,
I am new to the forum and was hoping that someone can help with my problem. Very grateful for the help already received from searching existing threads but can't find an answer to this one!
My problem is I've created an object from a custom class and can adjust the properties of the object and run methods while excel is open; but when I close excel and reopen it, although I can still see the object on the screen (It's a speedometer), I can't adjust properties or run methods. I guess this is because the variable that represents the object has been destroyed. Does anybody know how to preserve the object when excel closes?
Thanks for your help.
Bookmarks