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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to detect a col/row deletion? 1
Trapping events within a Workbook_SheetSelectionChange event 1
Error Installing "ADAPTEC EZCD 4.04" 1
Detect Autofilter Change Event 2
How to Capture right click Delete/Insert on Excel 8
detecting row or column insertion & deletion 5
Detect Excel minimize and restore? 5
Detecting Row Selection 1

Back
Top