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: 7
Default how to close a hidden spreadsheet?

I want to close the opened but not visible/hidden excelfile "macros.xls"
without saving when I will close the spreadsheet 'main.xls', leaving
"macros.xls' invisible so the next time it wil be opened it will still be
invisible. This hidden spreadsheet will not be the active sheet when the
macro will be performed.

Who can help me with a short code which I could put between the following
lines :

Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Sub


Thank you in advance!

Sabine


 
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
long time to close spreadsheet Don Excel Discussion (Misc queries) 1 September 5th 08 09:16 PM
Run Macro when close spreadsheet davemel Excel Discussion (Misc queries) 1 July 31st 06 02:03 PM
Hidden spreadsheet Di Blackborough Excel Discussion (Misc queries) 2 January 25th 06 02:15 PM
Dropdown list from another spreadsheet doesn't work if close sourc Kuche Excel Discussion (Misc queries) 1 June 30th 05 01:03 AM
Close Hidden Data Sheet Jeff Excel Programming 7 January 8th 05 09:48 PM


All times are GMT +1. The time now is 11:18 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"