Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
akkrug
 
Posts: n/a
Default Spell Checking an Excel Form

We have an Excel form that our users want to be able to spell check, but
cannot since the form is protected. I got a macro from you folks that does a
great job spell checking protected Word forms and thought you might be able
to point me to something similar in Excel.

Thanks.

Ken K.
--
akkrug
  #2   Report Post  
Paul B
 
Posts: n/a
Default Spell Checking an Excel Form

akkrug, some thing like this,

Sub Spell_Check()

'spell check a protected sheet, change password to yours

ActiveSheet.Unprotect password:="123"

Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _

, AlwaysSuggest:=True

ActiveSheet.Protect password:="123"

End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"akkrug" wrote in message
...
We have an Excel form that our users want to be able to spell check, but
cannot since the form is protected. I got a macro from you folks that
does a
great job spell checking protected Word forms and thought you might be
able
to point me to something similar in Excel.

Thanks.

Ken K.
--
akkrug



Reply
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 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Display form from an VB application in Excel kuhni Excel Discussion (Misc queries) 0 August 10th 05 06:04 PM
copying chart Excel into a vb form Julien Charts and Charting in Excel 2 June 27th 05 11:06 AM
I want to set up a form in excel where I can place a jpeg or pic. karl Excel Discussion (Misc queries) 1 June 25th 05 01:15 AM
How do I set up a field in an Excel form to number it incremental. max Excel Worksheet Functions 1 November 29th 04 10:33 PM


All times are GMT +1. The time now is 08:32 PM.

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

About Us

"It's about Microsoft Excel"