ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Closing a workbook exported to the website (https://www.excelbanter.com/excel-programming/361713-closing-workbook-exported-website.html)

Jim Jackson

Closing a workbook exported to the website
 
I have a workbook that is to be shared with our clients on our website.
There are numerous command buttons throughout the 40+ sheet workbook for
navigation purposes. When one sheet becomes visible the previous one is made
not visible. All the command buttons work perfectly except for the "Close"
button on the Menu sheet. It works as designed in the Excel Workbook state
but seems to need some different code in the Website state.

Private Sub CommandButton5_Click()
ActiveWorkbook.Close Savechanges:=False
End Sub

How can I change this to work on the website?

Thanks,

Jim Jackson


All times are GMT +1. The time now is 07:42 AM.

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