- Feb 5, 2006
- Office Version
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.