ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   spellcheck a textbox on a protected worksheet (https://www.excelbanter.com/excel-programming/408710-spellcheck-textbox-protected-worksheet.html)

dave caizley

spellcheck a textbox on a protected worksheet
 
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





All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com