Hi Guys,
I have added a scroll bar to my worksheet so that I can calculate percentages from 0% to 100%. The trouble is I want to protect my worksheet so certain cell with formulas cannot be deleted. I have selected the "Format Control" option and unticked "Locked" on the "Protection" tab. However when I lock the worksheet I cannot slide the values on the scroll bar.
I even tried unlocking the cells behind the scroll bar, however this does not work either.
Can anyone please explain how I can lock the sheet and still access the scroll bar.
Thanks in advance.
Bookmarks