pcain
03-26-2016, 05:13 AM
I would like to sTOP Excels spell checker checking text boxes.
It normally does not check them! There are lots of discussion about how to check them within Excel by copying the contents to a cell, checking them and then copying them back. I have done this and also used Words spell checker. Both work, Word best.
My code checks the text boxes then checks the cells using Excels spell checker. Once a text box has been checked once, the Excel spell checker will << SURPRISE >> also check the words in it whenever it runs, even after the Workbook is closed and reopened! I didn't think this was possible! It is still the horrible Excel spell checker showing only a single misspelled word out of context.
This is only an issue when "spelling mistakes" within the text box are not corrected (ignored). If there are no "spelling mistakes", then Excels spell checker gives no indication it has checked the text boxes.
I tried protecting the worksheets while leaving the cells unlocked. This prevents user changing textboxes but does not prevent Excels spell checker from checking or changing them. I have not been able to locate any reset options for the spell checker. And no API code that seems relevant.
Any other suggestions?
thanks
It normally does not check them! There are lots of discussion about how to check them within Excel by copying the contents to a cell, checking them and then copying them back. I have done this and also used Words spell checker. Both work, Word best.
My code checks the text boxes then checks the cells using Excels spell checker. Once a text box has been checked once, the Excel spell checker will << SURPRISE >> also check the words in it whenever it runs, even after the Workbook is closed and reopened! I didn't think this was possible! It is still the horrible Excel spell checker showing only a single misspelled word out of context.
This is only an issue when "spelling mistakes" within the text box are not corrected (ignored). If there are no "spelling mistakes", then Excels spell checker gives no indication it has checked the text boxes.
I tried protecting the worksheets while leaving the cells unlocked. This prevents user changing textboxes but does not prevent Excels spell checker from checking or changing them. I have not been able to locate any reset options for the spell checker. And no API code that seems relevant.
Any other suggestions?
thanks