ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   logging out (https://www.excelbanter.com/excel-programming/369184-logging-out.html)

tom

logging out
 
I have a Excel program that my department will be using on the web. I can log
out
of the program using a commandbutton while in the Excel program but having
problem (will not close) when using my browser. I would like to close out of
the program (workbook) and Excel (application) without saving are being asked
to save. The range address is to move the cursor to the top when the next
person logs on.

Private Sub CommandButton4_Click()
Range("a1").Select
xlApp.Quit
End Sub

Also, have try
ActiveWorkbook.Saved = True
Application.DisplayAlerts = False

As you can tell I'm new at this,
Thanks
Tom


All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com