Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello All,
I ws wondering on how I can protect a sheet that has nothing but formula's in it. My Scenario is this: I have a main sheet that I enter in all of my data into. from the other sheets, I use vlookup and other formula's to pull data into them. The problem that I am having is when I protect the whole sheet, then those cells that I have formulas in them won't update when I run my upate macro because they are protected. I don't want to un-protect those cells because, then a user may accidentally del, change, or erase that formua. Thanks in advance for any help Argus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sheet Protection | Excel Worksheet Functions | |||
Sheet Protection | Excel Worksheet Functions | |||
Sheet Protection | Excel Worksheet Functions | |||
sheet protection | Excel Worksheet Functions | |||
Sheet Protection | Excel Discussion (Misc queries) |