View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucas Reece Lucas Reece is offline
external usenet poster
 
Posts: 18
Default Disable row delete in a worksheet (not all worksheets in theworkbook)

Is it possible to prevent deleting of rows in a worksheet within a
workbook? e.g. I have Sheet1, Sheet2, Sheet3 and Sheet4 in the
workbook but only want to prevent deletion of rows in Sheet2.

Can someone offer a solution to this using VBA?

Many thanks.