Use the Workbook_BeforeClose event

Private Sub Workbook_BeforeClose(Cancel As Boolean)
auto_close macro here
End Sub

Lars Kofod

-----Original Message-----
I have an auto_close macro designed to reset toolbars
etc.
once a user has finished with the workbook.

Is it possible to prevent users being able to run the
macro whilst the workbook is in use?

Many Thanks

Paul Moles
PS The code is protected using project properties, I am
trying to stop premature running.

.