Security around VBA code & workbooks

[kenadams378]

Hi,

I'm keen to add some security around my code and wondered what the best way to do this is;

Ideally at the start of my code, the whole workbook would be unlocked and then the last part of the code would lock down all cells, formulae & sheets to avoid anyone changing anything in the outpot of the code.

Can anyone advise any little bits of code that can be useful?

Many Thanks

[Kyle123]

What type of "security" are you looking for?

Excel is extremely insecure without using external tools, however you can stop casual users poking about/putting things where they shouldn't

[kenadams378]

I just after some password protection, cell & formula protection to be applied as part of the code really.

Genereally to stop people changing data, totals & Stats etc

[kenadams378]

'Bump - No Response'