VBA Code to stop insert and delete

[Malcolm torishi]

Hi
can any one help please. Is there a way of stopping a user to insert or delete rows and columns by not protecting the sheets and keeping All other icons and functions still available on all ribbons
thank you

 

[hotabae]

On the sheet you want to protect, you should go to the review tab on the ribbon and click "Protect Sheet".

In my version (I'm not really familiar with others), there is a list of checkboxes including:

"Format Columns"
"Format Rows"
"Insert Columns"
"Insert Rows"
"Delete Columns"
"Delete Rows"

If you check those boxes but leave the others blank, that should accomplish what you're looking for.

Edit: This is the Normal Way to accomplish this, but the same thing can be done via VBA if you need that

 

[Malcolm torishi]

Hi thank you for coming back. One question will this still allow a user to have all icons and functions available on all ribbons

 

[hotabae]

Yes, If you use the insert and delete options, then everything outside of Inserting/Deleting should function normally.

Though an important note:

I said this before

If you check those boxes but leave the others blank, that should accomplish what you're looking for.

But Really, its the other way around. You want to check all the boxes EXCEPT the rows/columns options.