View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sabine[_4_] Sabine[_4_] is offline
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