You can't. Just think about the field day virus writers would have if you
could do that.

A commonly used technique is to make the key sheet hidden, and have some
workbook open code that makes it visible. Put some text on another sheet
warning the users about disabling macros and save it with this sheet active.
Not foolproof, but it helps.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Pete" wrote in message
...
Does anyone know how I can set my workbook to open without
giving the user the option of enabling or disabling the
macros I created?