Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

fileHow to allow spell check in a protected worksheet in Excel?

More
1 month 2 weeks ago #3837 by Mic@sha
can someone help my with this Q
see post!


Thanks for this. It has worked well, except that it changes my sheet protection settings every time I run it. I have my sheet protected, but set to allow users to format cells, columns, and rows; but after running this code, the protection is set back to the default. How can I retain my settings?You have to modify the .protect code by adding allow the criteria you want.Worksheets("Sheet1").Protect,:=False, AllowInsertingColumns:=False, AllowInsertingRows:=False,:=False, AllowFiltering:=False,
  • Mic@sha · 17 days ago So please help my with the correct code if possible, cant get it to work with AllowInsertingRows.Protect ("Welkom") and then?????? bit of a nob tot thismy worksheet (tabs)  is called for example P&A or BIOP

     

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansAmanda Lee