Locking cells containing formulas

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
361
Office Version
365
Platform
Windows
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...
 

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
361
Office Version
365
Platform
Windows
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...
 

Forum statistics

Threads
1,077,796
Messages
5,336,379
Members
399,079
Latest member
DeoW

Some videos you may like

This Week's Hot Topics

Top