I've created a worksheet which changes depending on the entry in the
Data Validation list but I like to hide all the formulas in this
worksheet.
I've tried selecting hidden in the Format/Protection and then selecting
lock cells Protect worksheet in Tools/Protection but then this does not
allow to select the drop down menu in the Data Validation box.
I dont want to lock cells as they change with dynamically with data
validation input PLUS I use Auto Filters but how can I still hide the
formulas.
Any suggestions
Thx
Bookmarks