how to close a hidden spreadsheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sabine - 25 Jan 2006 09:06 GMT

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

Reply to this Message

Bob Phillips - 25 Jan 2006 09:25 GMT

I don't think you will be able to do what you want as visible is not a
workbook property, but a property of the window. As Windows is part of
application, it is not saved when Excel closes.

One way I can think of doing it is to hold a defined name in the nominated
workbook with its window state, set it on closing, and test that on opening.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> I want to close the opened but not visible/hidden excelfile "macros.xls"
> without saving when I will close the spreadsheet 'main.xls', leaving
[quoted text clipped - 12 lines]
>
> Sabine

Reply to this Message