Prevent to insert new columns into excel sheet

[inokam]

I need to prevent or restrict to add new columns into excel sheet.

 

[inokam]

Hi,
I need to send this protected sheet to other user. That user should be able to add data validation. I am not able to share my password with them.

 

[inokam]

Hi,
I need to send this protected sheet to other user. That user should be able to add data validation. I am not able to share my password with them.

Hi, could you please help me to resolve this issue.

 

[DanteAmor]

One option, as I said, is that you recover the file, insert the validation and return the file to the user.
Another option is to add the validation using a macro, but you must create a macro for each validation possibility; or create a macro for some validation.

 

[inokam]

Hi DanteAmor,
I needs to do the following with data sheet.
- User should not be able to add new columns or delete columns from the sheet.
- But, user should be able to add data validations for drop down menus.
Ex: Designation
Under designation column, user should be able to add data validation list by selecting set of designations from another sheet.

Could you please help me to resolve this issue.

 

[DanteAmor]

I understand that, you want to have the protected sheet and insert validations, but it is not possible.
The idea is to create a macro with the following steps:- Check out the sheet
- Insert a validation
- Protect the sheet.

 

[inokam]

I understand that, you want to have the protected sheet and insert validations, but it is not possible.
The idea is to create a macro with the following steps:- Check out the sheet
- Insert a validation
- Protect the sheet.

Hi,
Thanks. Highly appreciate if I can get VBA code to prevent insert/delete columns.

 

[DanteAmor]

To avoid inserting rows or columns you must follow what I indicated in post #2