I have designed four forms for a small business just starting out. I have used Excel 2000 to create worksheets and want to protect everything except the fields that the user will fill in. When I try to "protect workbook", then "protect sheet", and then go back to "unlock" certain fields (like th help menu suggests)...... there is no menu selection for that.
It would seem that protecting the entire sheet is the only thing available? I would really like to protect everything EXCEPT what gets filled in, and then set the tab order appropriately. I had figured if it's possible in Access, then it must be possible in Excel??
Please advise if there is a way to do this.
Thanks in advance.
Fryan
It would seem that protecting the entire sheet is the only thing available? I would really like to protect everything EXCEPT what gets filled in, and then set the tab order appropriately. I had figured if it's possible in Access, then it must be possible in Excel??
Please advise if there is a way to do this.
Thanks in advance.
Fryan