Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking a worksheet, but allowing user to add rows in a table
I have been bustin my butt to find out how to allow a user to add rows (only)
to a table on a locked worksheet. Can anyone help me out? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking a worksheet, but allowing user to add rows in a table
Tools - Protection - Protect Sheet and check Insert Rows.
"Ray Carter" wrote: I have been bustin my butt to find out how to allow a user to add rows (only) to a table on a locked worksheet. Can anyone help me out? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking a worksheet, but allowing user to add rows in a table
I have tried that... It doesn't expand the table. BTW I am using 2007
version if that makes a difference. "Sean Timmons" wrote: Tools - Protection - Protect Sheet and check Insert Rows. "Ray Carter" wrote: I have been bustin my butt to find out how to allow a user to add rows (only) to a table on a locked worksheet. Can anyone help me out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I protect a number of sheets allowing the user to add a com | New Users to Excel | |||
locking text in a cell, but allowing new text to be added | New Users to Excel | |||
Allowing user to merge cells | Excel Discussion (Misc queries) | |||
Locking Rows/ Pivot table | Excel Worksheet Functions | |||
Unshared workbook allowing write access to more than 1 user | Excel Discussion (Misc queries) |