ExcelBanter - Locking a worksheet, but allowing user to add rows in a table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Locking a worksheet, but allowing user to add rows in a table (https://www.excelbanter.com/excel-worksheet-functions/203850-locking-worksheet-but-allowing-user-add-rows-table.html)

Ray Carter

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?

Sean Timmons

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?

Ray Carter[_2_]

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?

All times are GMT +1. The time now is 04:47 PM.