If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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" Range("A1:I1").Select End Sub Any help would be greatly appreciated. Thanks, Holly |
#2
|
|||
|
|||
2003 Macro in a 2007 World
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 |
Thread Tools | |
Display Modes | |
|
|