Hi,

I hope I haven't just wasted a few hours for nothing.

Manufacturing asked me to write some vba code behind one of their spreadsheets to prevent guys on the shop floor accidentally editing fields that they should not normally need to edit.
The protected cells are password protected and everything is working fine.

I don't get to do vba very often but I notice that on loading the form, if the user declines to allow macros to run, my code does not run and the user can edit whatever cells they want.

I appreciate the reason for the macro warning (viruses).
I also realise that you can change the protection level. Trouble with that is we are then open to virus attack and also the computer setting could be changed back again.

Is there any way to get my vba code to run irrespective of the macro protection level setting (I suspect the answer to that will be no)?
Alternatively, is there any way that I can prevent any of the sheet from being edited if macros are disabled?

Any help appreciated.