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
Bookmarks