How to detect an entire column/row delete event?

  • Thread starter Thread starter MV
  • Start date Start date
M

MV

I want to restrict this operation to my users but haven't been able to
detect this event.

thanks,
MV
 
MV,

Have you tried protecting the sheet? Format the cells that you want them to use as unlocked, then protect the sheet to prevent row
and/or column deletions.

If they should be able to delete some rows or columns, then you'll have to write utilities that unprotect the sheet, do the
deletion, then reprotect the sheet.

HTH,
Bernie
Excel MVP
 
Back
Top