VBA Protect - allow editing, not allow formatting or inserting columns

I am trying to write a macro that protects a sheets formatting - most specifically the cell size and margins. But I want to allow the cells themselves to be edited. I can't figure out what the correct settings are for this with the Protect command. I keep finding examples that do the opposite.

This is my current code and it doesn't stop columns from being inserted.

Sub SetProtection()
'
' SetProtection Macro
'

ActiveSheet.Protect UserInterfaceOnly, Contents:=False, AllowInsertingColumns:=False


End Sub

What am I doing wrong?

Thanks,
Deanna

Suppose you want to allow editing of two cell ranges: A3:G10 and B15:J30. You select the ranges in question, choose "Formatting cells" from the pop-up menu, select the Protection tab in the new window and uncheck the "Blocked" CheckBox. Now you can apply protection to the sheet.
The above actions can be performed with a macro:

Please Login or Register  to view this content.

Artik

So this can only be done with a range and not with the whole sheet then?

But all the cells in the worksheet are also a range.

Please Login or Register  to view this content.

Artik

Ah... I get it now. Thank you!

Deanna