I have a worksheet with a lot of formulas in it that i want to protect so the end user does not continually type over the formulas. Originally I had made sure that the cells with formulas were locked and protected the sheet - leaving the cells that the end user would need to change unlocked. Unfortunately with the workbook protected, the end user is not able to adjust the width of the columns or any other formatting like that. This is a function that she needs in order for it to print it out correctly.
I finally gave in and unprotected the workbook, but now i have to go back in randomly and correct formulas because they were accidentally deleted or typed over... i dont mind doing it, but i usually the end user doesnt realize it is not working properly until after they have sent out all the schedules and someone calls the wrong person because the number listed is not the correct one.
Is there a way to only lock the cells (and their content) and not have it affect the formatting abilities? I hope I have explained this well enough...
Thank you for taking the time to read this...
Nomi