Hidden Workbook

jgoulart · Mar 3rd, 2002, 02:49 PM

I am using a .xls file for a database that my control routine opens up to sort or pull data. Can I make this database .xls file open as a hidden workbook and if so, how would I code it?

John

dk · Mar 3rd, 2002, 03:33 PM

In the file you want to hide click Window, Hide. When you close Excel itselt it will ask you if you want to save changes to that workbook - say yes. Then when you next open the file it'll be hidden but you'll still be able to use formulae and add/retrieve data from it. Does that do the trick?

HTH,
D

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 02:49 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	I am using a .xls file for a database that my control routine opens up to sort or pull data. Can I make this database .xls file open as a hidden workbook and if so, how would I code it? John

Mar 3rd, 2002, 03:33 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	In the file you want to hide click Window, Hide. When you close Excel itselt it will ask you if you want to save changes to that workbook - say yes. Then when you next open the file it'll be hidden but you'll still be able to use formulae and add/retrieve data from it. Does that do the trick? HTH, D