Run a macro on system shutdown?

[WrldIntlR]

I have a macro that hides excel in the background that turns off remote requests. Half of the people that use it are too lazy to quit the userform before just pulling their cards or abandoning the workstations, so the next time they log in they freak out when Excel won't open any external application.

I've a .vbs that fixes the problem, but I'd prefer not to have to deal with it at all. Is there any way to call a macro on system shutdown?

Thanks,
James

 

[VoG]

You should be able to use the before close event in the ThisWorkbook module

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'
'do stuff
'
End Sub

 

[WrldIntlR]

I have a macro that hides excel in the background and turns off remote requests. Half of the people that use it are too lazy to quit the userform before just pulling their ID cards and abandoning their workstations, so the next time they log in they freak out when Excel opens files to an error and a grey screen.

I've a .vbs that fixes the problem, but I'd prefer not to have to deal with it at all. Is there any way to call a macro on system shutdown?

Thanks,
James

 

[WrldIntlR]

Will this work on a forced system time-out shutdown as well? if so, that would be grand. All i need to do is Application.IgnoreRemoteRequests = False.

 

[VoG]

Why have you just repeated your original question?

 

[WrldIntlR]

I can't speak English very well, so I was clarifying my original post. Apparently you can't edit a post after 10 minutes.

 

[WrldIntlR]

Didn't work Any other ideas?

 

[WrldIntlR]

This is my code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.IgnoreRemoteRequests = False
Application.Close
End Sub

And I'm getting
Runtime Error 438
Object Doesnt' support this property or method.

Any ideas?