I just hide sheets.
That confuses most. You can also make a repair macro that rewrites all the formula in the correct place, link that to a big button on sheet1 saying "REPAIR" which stops you being hassled unless they set their security settings to high.
(PsychoChomp, Mon 2 Sep 2013, 10:08, 1 reply, 12 years ago)

I don't understand what you just said.
But it doesn't matter because we've just set up this new SQL database and they can now use Excel to view the database, but they can't write to it so they get all the info they need but they can't fuck everything up.
(Bazongaloid, Mon 2 Sep 2013, 10:14, Reply)

I would like to register my name on the database please, can you add as the following
'; DROP TABLE customers; --


Chompy would get this, he's tight on the old SQL Injection Attack
( G/PP 💩💩💩💩💩&#128, Mon 2 Sep 2013, 10:30, Reply)

Obligatory XKCD
( Agnostic Antichrist Baltimora, Mon 2 Sep 2013, 10:43, Reply)