How to protect against user interference...

I need to protect a sheet from being changed or deleted by users, but almost ever cell in the workbook is used in a macro of some sort, and when i protect the sheet, it seems to stop all of that from working...
Any helps or tips?
Also, is there a way to set up a code so that, if at any point in the process something fails or bugs, it aborts the whole thing without changing anything?

Just create a routine to unprotect the sheet and call it at the start of each macro, then re-protect afterwards

Also, is there a way to set up a code so that, if at any point in the process something fails or bugs, it aborts the whole thing without changing anything?

That depends what you mean, if you mean like an undo, then there's nothing automated. The better solution is to check everything before running code to reduce the likelihood of error and then use error handling.

1. How would i creat the routine to unprotect and reprotect?
2. Problem is that most of the user using the sheet dont know a spec about VBA...

To Unprotect:

Please Login or Register  to view this content.

To protect:

Please Login or Register  to view this content.

They don't need to know VBA, you put it in

Thanks for the code...
2. they dont need to know VBA i realise, but if something bugs, and it pops up halfway through what they are trying to accomplish, they have no idea what to do...
and there are some silly little things that mess up, such as a data validation a A21:A45, where if you press enter twice in a row, it bugs out, and i can find out why... silly things like that, but i am not smart enough to figure them out... how do i best use error handling?