D
dave caizley
In a protected Workbook, users enter text into an unprotected Text Box. the
users cannot do a spellcheck because of the protection.
I can produce a simple macro to unprotect & start the spellcheck to work. I
then know how to re-protect the sheet but how do I identify when the spell
check has finished because every spell check is different. I guess it has to
be the code that happens when the spellcheck dialogue box closes but cannot
identify that code
Can anyone help
my basic macro is
Sub Spellcheck()
'
' Spellcheck Macro
' Macro recorded 04/06/2007
'
ActiveSheet.Unprotect Password:=â€Fredâ€
ActiveSheet.Shapes("Text Box 1").Select
Selection.CheckSpelling SpellLang:=2057
End Sub
users cannot do a spellcheck because of the protection.
I can produce a simple macro to unprotect & start the spellcheck to work. I
then know how to re-protect the sheet but how do I identify when the spell
check has finished because every spell check is different. I guess it has to
be the code that happens when the spellcheck dialogue box closes but cannot
identify that code
Can anyone help
my basic macro is
Sub Spellcheck()
'
' Spellcheck Macro
' Macro recorded 04/06/2007
'
ActiveSheet.Unprotect Password:=â€Fredâ€
ActiveSheet.Shapes("Text Box 1").Select
Selection.CheckSpelling SpellLang:=2057
End Sub