2003 Macro in a 2007 World



My company, in its infinite wisdom, has decided to upgrade some users to
Microsoft 2007 while leaving the rest of us in 2003. I set up a spreadsheet
with macro in Excel 2003. A user has updated data in the spreadsheet using
Excel 2007. He has then sent the spreadsheet to another user who is
attempting to run the macro in Excel 2003. Macro bombs out with the message
"Run-Time error '57121': Application-defined or object-defined error". Code
is as follows:

Sub Spell()
' Spell Macro
' Macro to allow spell checking of password protected Excel Forms
' Keyboard Shortcut: Ctrl+s
ActiveSheet.Unprotect Password:="password"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="password"
End Sub

Any help would be greatly appreciated.




Jon Peltier

The code works for me in 2003. Is the password correct? Is the active
sheet a chart?

- Jon

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