Thread: Locking a worksheet, but allowing user to add rows in a table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default 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?
Reply With QuoteReply With Quote