Thread: Locking a worksheet, but allowing user to add rows in a table
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ray Carter[_2_] Ray Carter[_2_] is offline
external usenet poster
  
Posts: 5
Default 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 With QuoteReply With Quote