G
GD
I have an issue whereby I have constructed quite a detailed report using a
variety of customised formulas - it took a lot of time, patience and help off
here! My concern is in utilising it, individuals have been either accidently
or not amending or incorrectly using the formulas - or in some cases taking
the credit for the work by butchering pieces for their own projects. Is it
possible to hide and password protect formulas so the report remains
operational but users have no access to formula composition? Or is it
possible to perhaps base these in one worksheet and password protect that,
retaining wider access to other sheets for all users of the workbook?
variety of customised formulas - it took a lot of time, patience and help off
here! My concern is in utilising it, individuals have been either accidently
or not amending or incorrectly using the formulas - or in some cases taking
the credit for the work by butchering pieces for their own projects. Is it
possible to hide and password protect formulas so the report remains
operational but users have no access to formula composition? Or is it
possible to perhaps base these in one worksheet and password protect that,
retaining wider access to other sheets for all users of the workbook?