I'm trying to add a exit button on my spread sheet that closes excel if no other workbooks are open or if others are open, it closes just my spreadsheet.
Any thoughts would be very helpful,
Jeremy
I'm trying to add a exit button on my spread sheet that closes excel if no other workbooks are open or if others are open, it closes just my spreadsheet.
Any thoughts would be very helpful,
Jeremy
[Code]
Sub ShutDown()
Workbooks("filename.xls").Save
Workbooks.Application.Quit
End Sub
[\Code]
Thanks Fifijazz, works great perfectly.
Don’t have an account yet? Register yourself now and be a part of our community!