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"
Range("A1:I1").Select
End Sub

Any help would be greatly appreciated.

Thanks,
Holly

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



hnyb1 wrote:
> 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"
> Range("A1:I1").Select
> End Sub
>
> Any help would be greatly appreciated.
>
> Thanks,
> Holly