Hi guys!
Is there a nice way of closing a open excel 97 application down. I want to have a button within a spreadsheet that allows the users to close and quit the excel applications, without the need to go to file ...exit.
ta
Gerard
Printable View
Hi guys!
Is there a nice way of closing a open excel 97 application down. I want to have a button within a spreadsheet that allows the users to close and quit the excel applications, without the need to go to file ...exit.
ta
Gerard
Hey May be this will help u
Open Excel
Select Toolbars->Forms
Add a button to the sheet
Select new to write code
use this code
Excel.Application.ActiveWorkbook.Save
Excel.Application.Quit
Try it!!!
Faisal
Press the switch with the word Power written on it, on the front of the computer.
Hope this helps.
td.
Works judt fine!!!
Thanks
Nice to hear my code works. Thanks..I feel like became a programmer