LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tia Tia is offline
external usenet poster
 
Posts: 64
Default protect worksheet but allow row deletion

My worksheet is protected and many cells are either locked or unlocked. Rows
A10:A31 are unlocked, however, a user cannont delete any row in the rows
mentioned. How can I make this happen?

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect files from deletion jayewink Excel Discussion (Misc queries) 3 July 24th 08 09:37 PM
Protect worksheet from deletion Richard Excel Discussion (Misc queries) 1 July 17th 06 03:38 PM
Protect formulas but allow deletion of rows? Hubitron2000 Excel Discussion (Misc queries) 1 March 21st 06 11:28 PM
protect a file from deletion SheriTingle Excel Discussion (Misc queries) 2 January 5th 06 01:32 AM
how can I protect workbook on a drive from deletion Gamez302 Excel Discussion (Misc queries) 4 May 20th 05 09:51 PM


All times are GMT +1. The time now is 09:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"