lzweifel
Board Regular
- Joined
- Feb 21, 2006
- Messages
- 213
In my worksheet I have a set of columns that I do not want the formula touched or seen. However, I need the user to be able to insert columns or delete columns, highlight, sort, etc.
The main object is to hide the formulas.
I have formatted the cells to HIDE and then protect the worksheet, checking off all the options (insert rows, insert columns, delete rows, etc) and then protect the sheet - it will still not allow the user to insert or delete a row.
What am I doing wrong, any ideas ??
THANKS
The main object is to hide the formulas.
I have formatted the cells to HIDE and then protect the worksheet, checking off all the options (insert rows, insert columns, delete rows, etc) and then protect the sheet - it will still not allow the user to insert or delete a row.
What am I doing wrong, any ideas ??
THANKS