Forum Discussion
Worksheet Protection question(s)
Take this to protect the worksheet with “Allow editing of objects”
• Go to Review > Protect Sheet.
• In the dialog, leave “Insert rows” / “Delete rows” / “Format cells” unchecked, but allow “Select unlocked cells”.
• Unlock the table’s data cells (via Format Cells > Protection > Unlocked) so users can still type into them.
• This way, the Convert to Range command is disabled because it counts as a structural change.
Take this to protect the worksheet with “Allow editing of objects”
• Go to Review > Protect Sheet.
• In the dialog, leave “Insert rows” / “Delete rows” / “Format cells” unchecked, but allow “Select unlocked cells”.
• Unlock the table’s data cells (via Format Cells > Protection > Unlocked) so users can still type into them.
• This way, the Convert to Range command is disabled because it counts as a structural change.