Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect some cells, but able to insert rows elsewhere?
I need to protect cells A1:C6, but be able to modify B1, and need to insert and delete rows below row 6. I selected the entire worksheet, unlocked the cells, then locked cells A1:C6, and unlocked B1. Thi worked fine for cell contents - when I protect the sheet, the cells are protected as I wanted, but I cannot insert or delete rows anywhere. Is there a way to accomplish the cell content protection as I did above, but be able to also insert and delete rows? Thanks! Alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=526765 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect some cells, but able to insert rows elsewhere?
in later versions of Excel this is possible. When you choose Tool Protect select the actions you want users to be able to perform before you set the password. Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=526765 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect some cells, but able to insert rows elsewhere?
Ed, "-...in later versions of Excel ...-" How recent version? The one I am using here is Excel 2000, and the options for protecting the sheet are for Contents, Objects, and Scenarios. These do not affect the ability to delete or insert rows; that is, regardless of which I check, I cannot insert or delete rows once the sheet is protected. Thanks Alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=526765 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect some cells, but able to insert rows elsewhere?
I'm using 2003, so I guess it came in somewhere after 2000 - sorry I can't help - it may be possible using vba. Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=526765 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect some cells, but able to insert rows elsewhere?
Excel 2000 does not have that function :( . If I am not mistaken it started from Excel 2002. Rgds. -- Infinity ------------------------------------------------------------------------ Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725 View this thread: http://www.excelforum.com/showthread...hreadid=526765 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect some cells, but able to insert rows elsewhere?
OK, I appreciate that. Now to the challenge of figuring out an alternate way of doing it - hmmm.... If anyone can figure out how to accomplish this 'long hand', please let us know. Then again, maybe I can convince the IT department to upgrade me to 2003. ;) Thanks all the same! :) Alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=526765 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect some cells, but able to insert rows elsewhere?
I guess they could only do as you can now - the features in a spreadsheet created by a later version are not avaialable to users of an earlier version that does not have them. ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=526765 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INSERT A ROW AFTER EVERY 5 CELLS IN A SHEET THAT HAS DATA OF 120 | Excel Discussion (Misc queries) | |||
insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
insert rows and update linked cells | Excel Discussion (Misc queries) |