LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Protect a block from line insert/delete

I have an Excel doc where there are two parts side-by-side. On the left is
the data that I manipulate - adding and removing lines as needed. On the
right side are the labels that I copy into the left side. These do not
change.

If I add or remove a line on the left side, I'd like to know if there is a
way to protect the right-side from line insertions and deletions?
 
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
alphabetize in a block, not just one line hilin Excel Discussion (Misc queries) 1 March 7th 07 01:35 PM
Protect / Block selected worksheet area . sansk_23 Excel Discussion (Misc queries) 1 February 13th 07 12:31 PM
Block Protect RhysPieces Excel Discussion (Misc queries) 3 May 5th 06 06:32 PM
How can I protect cells and allow users to insert/delete Jammy Dodger Excel Worksheet Functions 1 January 12th 06 10:20 AM
Protect Worksheet but allow to insert or delete rows Bob L Hilliard Excel Discussion (Misc queries) 2 June 9th 05 02:08 PM


All times are GMT +1. The time now is 01:35 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"