spellcheck

Hi folks, I have some locked spreadsheets which the users want to be able to perform a spellcheck on. By default spellcheck is disabled when the worksheet is locked. As far as I can see the only method of enabling the spell check is by way of a macro. Am I missing something simple? I can't see...

Hi gang, I am having an issue I'm hoping someone can help me out with. I need to run the spellcheck code below, however, I also need the "Format Rows" boxed check before the code completes the task (see screen shot below). I'm sure there is an easy fix -- I cant seem to figure it out. Your...

I hope someone can help me. I have a protected workbook with protected work sheets (2016). I built the spreadsheet with merged cells for user comments, but have now been asked to allow spell check in the comments field. In the example below I would need a text box/merged cell from b2:e3 (with...

Public Sub CheckSheetSpelling() Dim MySheet As Object Dim MyCell As Range Dim i As Integer, j As Integer Dim MySentence As String, MyWord As String Set MySheet = Sheets("sheet1") Set MyCell = MySheet.Range("A2") For Each MyCell In MySheet.UsedRange If...

Hello, I need your help in rectifying the code. This macro goes to certain columns, highlights the errors in magenta, creates a sheet and paste those errors there and also initiates a spellcheck. But I am receiving an error "Checkspelling method of range class failed". Here is my code: Sub...

Hi, I have a macro to spell check a protected workbook in excel 2010: Sub Spellcheck() ActiveSheet.Unprotect Password:="Project Delivery" Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False, AlwaysSuggest:=True, SpellLang:=2057 '2053 ActiveSheet.Protect...

How can I define an underscore (or any other character for that matter) to be a word separator? I have sentences such as "... use the vendor_name in the Initial_Load file ..." and both underscored compound words fail the standard spell check, but would succeed if treated separately. This is for...