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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save As 97-2003 workbook 1
Excel Protection 2
2003 Macro in Excel 2007 1
Are Excell 2007 macros backwaards compatible? 1
macro issues with excel 97 2
Excel checkbook register 2
Excel 2007 crashes when perform SAVE AS to Excel 97-2003 0
Excel 2003 code, problem in Excel 97 1

Back
Top