Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, 16 October 2021
  0 Replies
  4K Visits
0
Votes
Undo
can someone help my with this Q
see post!
https://nl.extendoffice.com/documents/excel/4378-excel-protect-sheet-but-allow-spell-check.html

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

  •  
There are no replies made for this post yet.