AXISHK
asked on
Prevent insert or delete rows and column with Excel VBA
Is it possible to prevent a user from insert / delete a row or column on a particular worksheet with Excel VBA ?
Tks
Tks
You can use worksheet protection for this. Why do you want to do this with VBA?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The VBA for the same is
ActiveSheet.Protect DrawingObjects:=AllowInser tingColumn s:=True, AllowInsertingRows:=True, _
AllowDeletingColumns:=True , AllowDeletingRows:=True
ActiveSheet.Protect DrawingObjects:=AllowInser
AllowDeletingColumns:=True
ASKER
How to modify the coding for checking the "INPUT" WORKSHEET only ?
Tks
Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks