Software
Hi,
I am going to create a database with drop down lists, hyperlinks and maybe some visual basic coding in Excel 97. After creating the database if I open it in Excel 2002 or any other version of Excel will any of the formatting be lost?
thanks
by dklippert
Shouldn't be a problem. Newer versions are backwards compatible.
I can't remember any VBA problems either.
by mailbarrow
Your Excel 97 VBA code will work fine in later versions - it's only if you were going back the other way that you may have difficulty as the more recent versions introduced some additional objects, properties and functions.
With regard to the hyperlinks, I'd suggest creating them using the =HYPERLINK function rather than the hyperlink object. The hyperlink object seems to give me grief sometimes in Excel 97.
If you really wanted to keep users from messing things up though, I'd recommend protecting the sheets (not that this is much protection for a sophisticated user), protecting your macros, and maybe even saving as read-only.
This discussion is closed to new replies.
Sort by Trending