Sheet Protection
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
|