I've created and recreated this sheet numerous times. The problem is that after using format cells; protection; locked to lock cells and in some cases locked/hidden to hide and lock the cells, then using protect sheet, my worksheet is forever corrupted. If I try to print the sheet or use print preview, I am tossed out of excel with one of those "Microsoft has encountered a problem and needs to close" errors. I am summarily tossed out of Excel and any open sheets are closed.

I sent the same sheet to another computer and the problem carries over to that computer so I am inclined to believe the sheet itself is corrupted somehow once I try to utilize hidden/locked cells and sheet protection.

I really need to be able to lock all but certain cells as this sheet geared for an end-user and is formula heavy.

Any ideas?