![]() |
spelling check on a protected spreadsheet
Thank you All, I've done it. I've used the Paul B approach:
Sub Spell_Check() ActiveSheet.Unprotect Password:="123" Cells.CheckSpelling _ CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False, _ AlwaysSuggest:=True ActiveSheet.Protect Password:="123" End Sub "Alex" wrote: Hi, Can I allow a user to do a spelling check on a protected spreadsheet if some cells/columns are awailable for the data entries? Thanks |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com