Hi Justin,

No that would be perfect. I only want it to apply to the one workboo
but I must be a little slow, because it hasn't worked for me yet.

Within the workbook, I have put it under Microsoft objects, in th
"ThisWorkbook".

Basically this is the code that I used:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

displayalerts = false

End Sub

Is this what you meant because it doesn't prevent the security warnin
on opening. People still get to choose to disable the macros and g
straight to the worksheets.

Any thoughts

--
toocol
-----------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...fo&userid=3160
View this thread: http://www.excelforum.com/showthread.php?threadid=52285