![]() |
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