practice for protecting formulas

[kragster]

Hi,
I have a rather large spreadsheat containing a table of data. Some of the cells contain data from user input, and some contain VLOOKUP formulas. What is the best practice for protecting these formulas? I tried making the cells with formulas writeprotected and then protecting the whole spreadsheet, but then it can not execute the formulas. What is the best practice for this?

Regards
Lars Kragh

 

[Bong]

This question is probably more appropriate to the MS Office forum as it does not actually require VBA.

To answer, however, you need to unlock all the cells to which you want the users to have access (the default protection of the cell format is locked). Then protect the worksheet and you should be fine.

_________________
Bob Rashkin