How to prevent user to insert / delete column?

[seageath]

Hi all,

Need help for this one, I try to detect if there is an inserted / deleted column in my worksheet. So far I only got how to set them in Worksheet.Sheetchange event:

If selection.Address = selection.EntireColumn.Address Then
        MsgBox ("You have made damaging modifications to the project sheet")
        ' Need the code here
        Exit Sub
End If

I only want to prevent user to insert / delete the column.
Appreciate for all the help.

-sea-

 

[Ruddles]

You could protect the worksheet and allow them to do everything except insert and delete rows. No code required.

 

[seageath]

You could protect the worksheet and allow them to do everything except insert and delete rows. No code required.

I want to do this using macro, since these worksheet will be distributed to the user but only allowed them to modify specific worksheet.

 

[Ruddles]

I don't understand your reasoning. Using worksheet protection will always work; doing it by a macro will not work unless the user actually enables macros.

 

[seageath]

I don't understand your reasoning. Using worksheet protection will always work; doing it by a macro will not work unless the user actually enables macros.

We have project's worksheet for several users. We use macro since we are implementing macros for

- log the update-
- insert new row
- update the value
- upload the update to database

but users can not insert or delete column since it will damages the calculation of entire workbook.

Hope it's clear why we need to implement macros.

-sea-

 

[Ruddles]

No, sorry, it's still not clear. I understand that you're using macros but I don't understand why you'd want to go to the complexity of implementing this sort of functionality in VBA when it's already provided as a basic function of the worksheet.

Thanks for explaining but I think I'll dip out at this point and leave this for someone else to respond to.

 

[seageath]

No, sorry, it's still not clear. I understand that you're using macros but I don't understand why you'd want to go to the complexity of implementing this sort of functionality in VBA when it's already provided as a basic function of the worksheet.

Thanks for explaining but I think I'll dip out at this point and leave this for someone else to respond to.

Thanks for your pov

-sea-