Message "class not registered" opening sheet with macros Excel 97

P

PlanetSavers

I have created a document with Macros and is password protected. I have sent
it to several people who are able to use it - the one who can't is using
Excel 97 SP2. They are getting error message "class not registered" - could
it be the version they are using and how do I make sure they are able to use
it.
 
N

Nick Hodge

This could simply be a version issue if you developed on a later version and
used controls from that versions object libraries. You should always use the
lowest version to develop on.

If this is not the case look in the VBE on the faulty machine and check
tools>references... and see if any are marked as missing. These are the
ones that need to be added. Could just mean a full install of that machines
version.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top