Hi I need to close a worksheet with a button, so I need a macro to attach. Thanksing you
L Lloyd Jan 23, 2007 #1 Hi I need to close a worksheet with a button, so I need a macro to attach. Thanksing you
M Mike Jan 23, 2007 #2 You can't close a worksheet, you can hide it or switch to another sheet or even close the workbook. Which do you want to do? You can switch to
You can't close a worksheet, you can hide it or switch to another sheet or even close the workbook. Which do you want to do? You can switch to
M Mike Jan 23, 2007 #3 try this Sub Button1_Click() ActiveWorkbook.Close savechanges = True End Sub savechanges could also be False
try this Sub Button1_Click() ActiveWorkbook.Close savechanges = True End Sub savechanges could also be False
