LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 324
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing a workbook N1KO Excel Discussion (Misc queries) 0 February 12th 09 03:51 PM
Excel 2007 workbook not linking properly with authentic website Mr. Larson Excel Discussion (Misc queries) 0 June 5th 08 03:15 AM
Closing Hidden Workbook when Active Workbook is Closed SusanK521 Excel Programming 5 September 24th 05 12:27 AM
Closing workbook Ed Excel Programming 4 February 6th 04 03:41 PM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"