Click here to Skip to main content
12,950,099 members (39,792 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
HI Friends,

Can We delete a row in a protected work sheet?

I put DeleteRows = false in SheetProtection class attributes then I am able to find option for deleting the row by giving right click on excel row.

Still, I can't able to delete. It is showing the message that the sheet is protected so first unprotect it and delete the row.

Please help me in this.
Posted 22-Nov-12 23:44pm
Updated 23-Nov-12 6:00am
RaisKazi34.6K
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

In your protect method put AllowDeletingRows = true.
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,749
CHill60 3,380
Maciej Los 2,953
Jochen Arndt 1,935
ppolymorphe 1,820


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 23 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100