Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Peter
 
Posts: n/a
Default Spell Check w/ Protection

Does anyone know how you can enable spell checking for a protected worksheet?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
you can't. You may record a macro which first unprotects the sheet, executes
spell checking and protects the sheet again

--
Regards
Frank Kabel
Frankfurt, Germany

Peter wrote:
Does anyone know how you can enable spell checking for a protected
worksheet?



  #3   Report Post  
Peter
 
Posts: n/a
Default

Thank You. Excellent suggestion that I think will do the job. Have a Happy
New Year.

"Frank Kabel" wrote:

Hi
you can't. You may record a macro which first unprotects the sheet, executes
spell checking and protects the sheet again

--
Regards
Frank Kabel
Frankfurt, Germany

Peter wrote:
Does anyone know how you can enable spell checking for a protected
worksheet?




  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
sheet.

Similar to.......

Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Gord Dibben Excel MVP

On Wed, 29 Dec 2004 12:33:05 -0800, "Peter"
wrote:

Thank You. Excellent suggestion that I think will do the job. Have a Happy
New Year.

"Frank Kabel" wrote:

Hi
you can't. You may record a macro which first unprotects the sheet, executes
spell checking and protects the sheet again

--
Regards
Frank Kabel
Frankfurt, Germany

Peter wrote:
Does anyone know how you can enable spell checking for a protected
worksheet?





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
Seeking help for total worksheet protection Joseph Geretz Excel Discussion (Misc queries) 10 December 31st 04 07:48 PM
library check in and out bookworm Excel Discussion (Misc queries) 1 December 18th 04 01:45 AM
Using a Check Box as a control item Dan G Excel Discussion (Misc queries) 2 December 14th 04 08:59 PM
How may I remove Office 2003 DRM protection from DOC & XLS files? Locked out Excel Discussion (Misc queries) 1 December 12th 04 06:22 PM
Why does spelling check close Excel when checking spanish? RCP Excel Discussion (Misc queries) 2 December 4th 04 08:37 PM


All times are GMT +1. The time now is 09:24 AM.

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"