Locking cells containing formulas

[Dan Wilson]

Good day. I am running Excel 2013 out of Office 365 on Windows 10 Home. I have created a rather extensive workbook containing seven worksheets and twenty Macros. Each worksheet has cells that allow the user to enter data. The other cells contain formulas. I want to make this workbook available to other users who have an interest in tracking the data to be entered. The cells accessible to the user for data entry are all shaded. The cells containing formulas are not shaded. Is there a way to format the cells containing formulas so that the user cannot edit those cells? The Macros will be used to sort the data in several different ways. Any help is appreciated.
Thanks,
Danno...

 

[joshman108]

Can you just lock the cells manually?

 

[Dan Wilson]

Good day joshman108. Thank you for responding. After reading the Help file on Protection, I tried removing the "lock" format of the user accessible cells. Then I chose to Protect the Worksheet. That did allow me to enter data where I wanted to and not enter data where I didn't want it. I then tried running one of the Macros on that worksheet and it failed while trying to set the Color on the unlocked cells. I tried the same thing on the other worksheets and the results are the same. Did I do something wrong?
Thanks, Danno...