LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default 2003 Macro in Excel 2007

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Macro taking long time in Excel 2007 Satish Excel Discussion (Misc queries) 3 November 3rd 09 04:58 PM
Run excel 2007 from Access 2003 Runapp macro Henning Leo Excel Discussion (Misc queries) 0 November 4th 08 09:55 AM
macro between 2003 and 2007 Debbie Horner Excel Discussion (Misc queries) 1 October 15th 08 03:16 PM
Macro for Pivot in MS Excel 2003 vs 2007 MichaelR Excel Discussion (Misc queries) 1 July 25th 08 01:02 AM
Excel 2007 Macro Help (Excel 2003 not working in 2007) Pman Excel Discussion (Misc queries) 4 May 29th 08 06:29 PM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"