Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a spreadsheet with a macro that I set up in Excel 2003. This spreadsheet was then sent to a user who has Microsoft 2007. He opened the macro added information and then sent to another user who has Microsoft 2003. When that user opened the file and attempted to run the macro it bombed out with the message "Run Time Failure '32809': 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 I am at a complete loss and any help would be greatly appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 Macro taking long time in Excel 2007 | Excel Discussion (Misc queries) | |||
Run excel 2007 from Access 2003 Runapp macro | Excel Discussion (Misc queries) | |||
macro between 2003 and 2007 | Excel Discussion (Misc queries) | |||
Macro for Pivot in MS Excel 2003 vs 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) |