Hi Paul

What if the user want to have several open files simoultaneously ? I'd expect my toolbars
to look and work as always when I'm in the not-your-workbooks. Consider to use the
activate / deactivate events instead. Paste this in the ThisWorkbook module:

Private Sub Workbook_WindowActivate(ByVal Wn As Window)
MsgBox "Active"
End Sub

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
MsgBox "Gone"
End Sub

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Paul Moles" wrote in 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.