Anyone know how to open a work book through code and suppress the any code
that is in the open event of the book being opened?

I know you can do it manually by holding the shift key to go into design
mode so there must be a VBA equivalent mustn't there?