View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
OdAwG OdAwG is offline
external usenet poster
 
Posts: 35
Default 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