TROUBLES WITH PROTECTION

[lzweifel]

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

 

[dave3009]

Have you protected the structure of the workbook itself. This might cause the problem. I had a similar issue which turned out to be related to workbook protection.

Hope this helps

Dave

 

[lzweifel]

I changed the protection from STRUCTURE to WINDOWS (Have to chose one or the other) and it didn't make a difference ????

 

[dave3009]

Does it need to be on? If you don't have any hidden sheets then it may not be necessary. An alternative might be to use code to temporarily unprotect the workbook then reprotect after the user has inserted the row/column.

Dave