using Spell check on protected sheet
 

Hello,

I have selected sections of a worksheet and Unlocked the Cells so that when
I protect the sheet the user can still enter in certain cells. However
Spell Check is not available in any cells.

Is there a way to have the sheet protected but allow the user to the use of
Spell Check in the cells that they have access too.

I look forward to any help.

Thank you!
--
Thanks, Pat

using Spell check on protected sheet
 

Pat,

Use a macro to fleetingly unprotect the sheet and then re-protect. Alt +F11
to open VB editor, right click 'ThisWorkbook' and insert module and paste the
code in

Put a button on your sheet to call it


Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Cells.CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike


"Pat" wrote:

Hello,

I have selected sections of a worksheet and Unlocked the Cells so that when
I protect the sheet the user can still enter in certain cells. However
Spell Check is not available in any cells.

Is there a way to have the sheet protected but allow the user to the use of
Spell Check in the cells that they have access too.

I look forward to any help.

Thank you!
--
Thanks, Pat

using Spell check on protected sheet
 

I had thought of a Macro - however would one macro allow someone to stop and
correct the spelling and then continue to protect the sheet? Or would it
involve two macros?

--
Thanks, Pat


"Mike H" wrote:

Pat,

Use a macro to fleetingly unprotect the sheet and then re-protect. Alt +F11
to open VB editor, right click 'ThisWorkbook' and insert module and paste the
code in

Put a button on your sheet to call it


Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Cells.CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike


"Pat" wrote:

Hello,

I have selected sections of a worksheet and Unlocked the Cells so that when
I protect the sheet the user can still enter in certain cells. However
Spell Check is not available in any cells.

Is there a way to have the sheet protected but allow the user to the use of
Spell Check in the cells that they have access too.

I look forward to any help.

Thank you!
--
Thanks, Pat

using Spell check on protected sheet
 

Hi,

The macro I gave you does precisely that, it unprotects the sheet for the
spellcheck and re-protects on completion.

Mike

"Pat" wrote:

I had thought of a Macro - however would one macro allow someone to stop and
correct the spelling and then continue to protect the sheet? Or would it
involve two macros?

--
Thanks, Pat


"Mike H" wrote:

Pat,

Use a macro to fleetingly unprotect the sheet and then re-protect. Alt +F11
to open VB editor, right click 'ThisWorkbook' and insert module and paste the
code in

Put a button on your sheet to call it


Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Cells.CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike


"Pat" wrote:

Hello,

I have selected sections of a worksheet and Unlocked the Cells so that when
I protect the sheet the user can still enter in certain cells. However
Spell Check is not available in any cells.

Is there a way to have the sheet protected but allow the user to the use of
Spell Check in the cells that they have access too.

I look forward to any help.

Thank you!
--
Thanks, Pat

using Spell check on protected sheet
 

WOW! that is awesome.
One more snag thou - is it possible to choose the area that we want spell
check to work on? This particular file has a lot of abbreviations and
formulas which spell check stops at. The area I would like to have checked
is B7 - I25

Thanks again.

--
Thanks, Pat


"Mike H" wrote:

Hi,

The macro I gave you does precisely that, it unprotects the sheet for the
spellcheck and re-protects on completion.

Mike

"Pat" wrote:

I had thought of a Macro - however would one macro allow someone to stop and
correct the spelling and then continue to protect the sheet? Or would it
involve two macros?

--
Thanks, Pat


"Mike H" wrote:

Pat,

Use a macro to fleetingly unprotect the sheet and then re-protect. Alt +F11
to open VB editor, right click 'ThisWorkbook' and insert module and paste the
code in

Put a button on your sheet to call it


Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Cells.CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike


"Pat" wrote:

Hello,

I have selected sections of a worksheet and Unlocked the Cells so that when
I protect the sheet the user can still enter in certain cells. However
Spell Check is not available in any cells.

Is there a way to have the sheet protected but allow the user to the use of
Spell Check in the cells that they have access too.

I look forward to any help.

Thank you!
--
Thanks, Pat

using Spell check on protected sheet
 

Pat,

Simplt specify the range

Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Range("B7:I25").CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike

"Pat" wrote:

WOW! that is awesome.
One more snag thou - is it possible to choose the area that we want spell
check to work on? This particular file has a lot of abbreviations and
formulas which spell check stops at. The area I would like to have checked
is B7 - I25

Thanks again.

--
Thanks, Pat


"Mike H" wrote:

Hi,

The macro I gave you does precisely that, it unprotects the sheet for the
spellcheck and re-protects on completion.

Mike

"Pat" wrote:

I had thought of a Macro - however would one macro allow someone to stop and
correct the spelling and then continue to protect the sheet? Or would it
involve two macros?

--
Thanks, Pat


"Mike H" wrote:

Pat,

Use a macro to fleetingly unprotect the sheet and then re-protect. Alt +F11
to open VB editor, right click 'ThisWorkbook' and insert module and paste the
code in

Put a button on your sheet to call it


Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Cells.CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike


"Pat" wrote:

Hello,

I have selected sections of a worksheet and Unlocked the Cells so that when
I protect the sheet the user can still enter in certain cells. However
Spell Check is not available in any cells.

Is there a way to have the sheet protected but allow the user to the use of
Spell Check in the cells that they have access too.

I look forward to any help.

Thank you!
--
Thanks, Pat

using Spell check on protected sheet
 

PERFECT!!
Mike you are my HERO!
Thank you very much for your quick response and great info. ;)

Have a wonderful weekend.

--
Thanks, Pat


"Mike H" wrote:

Pat,

Simplt specify the range

Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Range("B7:I25").CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike

"Pat" wrote:

WOW! that is awesome.
One more snag thou - is it possible to choose the area that we want spell
check to work on? This particular file has a lot of abbreviations and
formulas which spell check stops at. The area I would like to have checked
is B7 - I25

Thanks again.

--
Thanks, Pat


"Mike H" wrote:

Hi,

The macro I gave you does precisely that, it unprotects the sheet for the
spellcheck and re-protects on completion.

Mike

"Pat" wrote:

I had thought of a Macro - however would one macro allow someone to stop and
correct the spelling and then continue to protect the sheet? Or would it
involve two macros?

--
Thanks, Pat


"Mike H" wrote:

Pat,

Use a macro to fleetingly unprotect the sheet and then re-protect. Alt +F11
to open VB editor, right click 'ThisWorkbook' and insert module and paste the
code in

Put a button on your sheet to call it


Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Cells.CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike


"Pat" wrote:

Hello,

I have selected sections of a worksheet and Unlocked the Cells so that when
I protect the sheet the user can still enter in certain cells. However
Spell Check is not available in any cells.

Is there a way to have the sheet protected but allow the user to the use of
Spell Check in the cells that they have access too.

I look forward to any help.

Thank you!
--
Thanks, Pat

using Spell check on protected sheet
 

Glad I could help

On Fri, 13 Mar 2009 14:05:01 -0700, Pat
.(donotspam) wrote:

PERFECT!!
Mike you are my HERO!
Thank you very much for your quick response and great info. ;)

Have a wonderful weekend.