#1   Report Post  
Old November 14th 04, 08:53 AM
steve
 
Posts: n/a
Default Protected sheets

Hello
I made up a sheet for workers to fill out and then I protected the cells I
don't want them to be able to change. but now with the sheet protected the
spell checker doesn't work. can it be set up to run on a protected work sheet
?
Thank You
--
steve

  #2   Report Post  
Old November 14th 04, 09:14 AM
Frank Kabel
 
Posts: n/a
Default

Hi
no you can't. The best you could do is for exampl:
- start recording a macro
- unprotect the sheet
- start the spell checker
- protect the sheet again

Now ue this recorded macro


--
Regards
Frank Kabel
Frankfurt, Germany


steve wrote:
Hello
I made up a sheet for workers to fill out and then I protected the
cells I don't want them to be able to change. but now with the sheet
protected the spell checker doesn't work. can it be set up to run on
a protected work sheet ?
Thank You

  #3   Report Post  
Old November 14th 04, 05:53 PM
Gord Dibben
 
Posts: n/a
Default

Steve

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 Sun, 14 Nov 2004 00:53:01 -0800, "steve"
wrote:

Hello
I made up a sheet for workers to fill out and then I protected the cells I
don't want them to be able to change. but now with the sheet protected the
spell checker doesn't work. can it be set up to run on a protected work sheet
?
Thank You




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
Can't open protected sheets Laurent Imbault Setting up and Configuration of Excel 2 January 14th 05 03:07 PM
Protected Sheets or other security Excel GuRu Excel Discussion (Misc queries) 3 January 11th 05 09:25 AM
PROTECTING/UNPROTECTING SHEETS Maureen Excel Discussion (Misc queries) 1 January 6th 05 06:46 PM
Grouping in protected sheets Maia Excel Discussion (Misc queries) 1 January 3rd 05 04:04 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 11:15 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017