Prevent inserting column by user

I have protected the sheet with password. But I need to protect/prevent first 10 columns ( A:J) being deleted or inserted with new column by user. Looking for vb code.
Thanks in advance.

Follow these steps,

1. Go to the Visual Basic Editor by pressing the keys Alt+F11.

2. From the Project Explorer, double-click over the ThisWorkbook object

3. That will execute an event window for you. At the top of the new code window, you will see the word 'General'. Select the drop down where you see general and select 'Workbook'.

4. You will notice that Excel VBA assumes the Open event. That means whatever code you insert in this procedure will execute automatically when the workbook is opened.

Please Login or Register  to view this content.

Originally Posted by abduljaleel.mca

Follow these steps,

1. Go to the Visual Basic Editor by pressing the keys Alt+F11.

2. From the Project Explorer, double-click over the ThisWorkbook object

3. That will execute an event window for you. At the top of the new code window, you will see the word 'General'. Select the drop down where you see general and select 'Workbook'.

4. You will notice that Excel VBA assumes the Open event. That means whatever code you insert in this procedure will execute automatically when the workbook is opened.

Please Login or Register  to view this content.

Hi Abdul,
It does not work the way I wanted. 1). It's block all columns from inserting 2) once unprotected user can still can insert
3) runtime error 1004 when reopen.

Jaleel,
Some how we are sync. see attached
Prevent Insert Column.jpg