Thread: Avoid user to access first two rows in a sheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
kkknie[_161_] kkknie[_161_] is offline
external usenet poster
  
Posts: 1
Default Avoid user to access first two rows in a sheet
Why not just protect the worksheet.

First select all cells choose Cells from the Format window.
Under the Protection tab, uncheck the Locked checkbox.
Now select the first two rows and choose format Cells again.
Check the locked checkbox.
Now from Tools menu, select Protection | Protect Sheet.
Select a password if you wish.

Now the users will not be able to change the first two rows of th
spreadsheet.



--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote