a macro ?

eddieque · Apr 4th, 2002, 05:54 PM

I created a workbook for a class project. I have navigation buttons that move me thru it forward and backward. What I would like to do is create a macro for a button that closes excel and doesnt ask for the save prompt.

NateO · Apr 4th, 2002, 05:55 PM

Try:

Code:

sub clsIt()
Dim myAp As Excel.Application
thisworkbook.close false
myAp.quit
end sub

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-04-04 17:01 ]

eddieque · Apr 9th, 2002, 11:08 AM

Thanks for the help. However it doesnt close Excel. It closes the Workbook just fine but not the program. Any suggestions about that ?

Al Chara · Apr 9th, 2002, 11:18 AM

Try the following:

With Application
.DisplayAlerts = False
.Quit
End With

eddieque · Apr 9th, 2002, 11:23 AM

Thank You that work super

Much appreciated.
I gave this site to my teach.

Cosmos75 · Apr 9th, 2002, 12:56 PM

See topic below

http://www.mrexcel.com/board/viewtop...c=4261&forum=2

Cosmos75 · Apr 14th, 2002, 10:46 PM

eddieque,

What do you mean you have a macro that move you forward and backward through your workbook? You mean go from one worksheet to the next and back?

Care to share the code for that?

Apr 4th, 2002, 05:55 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Try: Code: sub clsIt() Dim myAp As Excel.Application thisworkbook.close false myAp.quit end sub _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-04-04 17:01 ]

Apr 9th, 2002, 11:18 AM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following: With Application .DisplayAlerts = False .Quit End With __________________ Kind regards, Al Chara

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

Apr 4th, 2002, 05:54 PM	#1
eddieque New Member Join Date: Feb 2002 Posts: 26	I created a workbook for a class project. I have navigation buttons that move me thru it forward and backward. What I would like to do is create a macro for a button that closes excel and doesnt ask for the save prompt.

Apr 9th, 2002, 11:08 AM	#3
eddieque New Member Join Date: Feb 2002 Posts: 26	Thanks for the help. However it doesnt close Excel. It closes the Workbook just fine but not the program. Any suggestions about that ?

Apr 9th, 2002, 11:23 AM	#5
eddieque New Member Join Date: Feb 2002 Posts: 26	Thank You that work super Much appreciated. I gave this site to my teach.

Apr 9th, 2002, 12:56 PM	#6
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	See topic below http://www.mrexcel.com/board/viewtop...c=4261&forum=2

Apr 14th, 2002, 10:46 PM	#7
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	eddieque, What do you mean you have a macro that move you forward and backward through your workbook? You mean go from one worksheet to the next and back? Care to share the code for that?