Close a Workbook

dantb · Apr 5th, 2002, 09:45 PM

Hi all, Beginer here. Is there a way to Close a Workbook ?, I am trying to have a Cmd button that Closes a workbook, and after, return to another.

Anne Troy · Apr 5th, 2002, 10:00 PM

Return to another specific workbook?

dantb · Apr 5th, 2002, 10:09 PM

Yes, I have a cmd button, that opens a workbook, the workbook is protected (windows). The Prob is , when I connect, since it is protected windows, there is no close button. And If I close, It closes All Workbooks

Anne Troy · Apr 5th, 2002, 10:10 PM

So, if I'm right, you want a command button in Workbook 2 that will open and close Workbook 1??

Not very difficult, if that's what you want.

dantb · Apr 5th, 2002, 10:13 PM

Yes Dream, Just a simple close the workbook, and return to previous book

Anne Troy · Apr 5th, 2002, 10:13 PM

Give me a few...

Anne Troy · Apr 5th, 2002, 10:16 PM

You've tried this?

Windows("WorkbookName.xls").Activate
ActiveWorkbook.Close

dantb · Apr 5th, 2002, 10:19 PM

Like I said, a beginer Dream. Im sure that is the correct code, I just couldnt figure it out.. Thx you so much Dan

Anne Troy · Apr 5th, 2002, 10:48 PM

Cool! Cause I sure don't consider myself a coder. I recorded that one, Dan.

Apr 5th, 2002, 10:00 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Return to another specific workbook? __________________ ~Anne Troy

Apr 5th, 2002, 10:10 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	So, if I'm right, you want a command button in Workbook 2 that will open and close Workbook 1?? Not very difficult, if that's what you want. __________________ ~Anne Troy

Apr 5th, 2002, 10:13 PM	#6
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Give me a few... __________________ ~Anne Troy

Apr 5th, 2002, 10:16 PM	#7
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	You've tried this? Windows("WorkbookName.xls").Activate ActiveWorkbook.Close __________________ ~Anne Troy

Apr 5th, 2002, 10:48 PM	#9
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Cool! Cause I sure don't consider myself a coder. I recorded that one, Dan. __________________ ~Anne Troy

Apr 5th, 2002, 09:45 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Hi all, Beginer here. Is there a way to Close a Workbook ?, I am trying to have a Cmd button that Closes a workbook, and after, return to another.

Apr 5th, 2002, 10:09 PM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Yes, I have a cmd button, that opens a workbook, the workbook is protected (windows). The Prob is , when I connect, since it is protected windows, there is no close button. And If I close, It closes All Workbooks

Apr 5th, 2002, 10:19 PM	#8
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Like I said, a beginer Dream. Im sure that is the correct code, I just couldnt figure it out.. Thx you so much Dan

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