A Aidan Jan 23, 2004 #1 How do i make a button in a spread sheet that will close the sheet? and also one that will close excel?
How do i make a button in a spread sheet that will close the sheet? and also one that will close excel?
N Nigel Jan 23, 2004 #2 To close the workbook put this in the button code...... ActiveWindow.Close To quit Excel put this in the button code...... Application.Quit Cheers Nigel
To close the workbook put this in the button code...... ActiveWindow.Close To quit Excel put this in the button code...... Application.Quit Cheers Nigel