Cell / Workbook protection

[Guest]

I have an Excel template with numerous sheets. Several of the sheets have a
database query which auto refreshes when the workbook is opened. The
remaining sheets do not import any data but contain numerous formulas which I
would like to protect. I have tried protecting / unprotecting the cells,
passwording the workbook, etc - but can not figure out a way to keep my
formulas protected that still allows the user to import the data. The only
thing the user needs to be able to do is import the data and do a sort on the
sheets. Everything I've tried to do will not allow them to import or refresh
the data. Any ideas?

 

[Garry]

Hi Cheryl,
There's a couple things you can try. First unlock all
cells that do not contain formulas, then protect the sheet
(s). Alternatively, if the data import and sort can be
handled with a macro then you can set this protection
parameter: Userinterfaceonly:=True in your code to set the
sheet protection. This will allow code to update the
sheets but keep access to the user restricted to unlocked
cells only. Excel on-line help has lots more info on this
if you care to use it.
Hope it helps, Regards