Disable/Hide Insert and Delete Row/Column Functions

Hi guys,

I am working on a project tracking template for multiple workers. I created a macro to insert a range above a selected row (with all formulas inserted as well).

What I need to do is block end users from being able to insert and delete rows and/or columns. What VBA code or macro should I use to accomplish this?

SeanPratt,

Would locking the sheets be an option? You can use VBA to lock the sheet so that everything still works other than inserting or deleting rows and columns. As you need the sheet unprotected for your code to run you can unlock the sheet, run your code and then lock the sheet.

The code to unlock the sheet before your existing code would be;

Please Login or Register  to view this content.

The code to lock the sheet after your existing code would be;

Please Login or Register  to view this content.

Mowgli

If I lock the sheets, will end users need to unlock them to up required fields (activty, project, hours)?

Normally yes, however ...

Select all cells in the sheet (right-click on the area to the left of ColumnA and above Row1)
Go to "Format Cells" and then go to the "Protection" tab
Ensure that the checkbox "Locked" is UNCHECKED

Users will be able to work away when the sheet is locked without being much the wiser... unless they try to insert or delete rows or columns

Excellent. Thank you

Let me know if it does what you want or if it is not suitable

Works great.

Thanks

Don't forget to mark your thread solved if you are happy