Closing worksheets
Closing worksheets
(OP)
I have a series of worksheets that I can open from a main switchboard similar to acces through command buttons. How can close a worksheet and return to the main sheet without it completely closing excel. The other sheets open through vba commands.





RE: Closing worksheets
One simple method (instead of hiding the shets) is to turn off the sheet tabs under <tools><options>.
On each sub sheet just add a button similar to the ones on the "Switchboard" each referencing back to the "switchboard" sheet name, e.g. the code would be.
Sub GoToFrontsheet()
Sheets("Frontsheet").Select
End Sub
Hope this helps
Regards
Mogens
RE: Closing worksheets
Workbooks("BOOK1.XLS").Close SaveChanges:=False
Obviously, you should replace BOOK1.XLS by the name of the workbook you're closing.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Closing worksheets
I think that answers my question.