Close worksheet by means of a macro
try this
Sub Button1_Click()
ActiveWorkbook.Close savechanges = True
End Sub
savechanges could also be False
"Lloyd" wrote:
Sorry I met WorkBook
"Mike" wrote:
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
"Lloyd" wrote:
Hi
I need to close a worksheet with a button, so I need a macro to attach.
Thanksing you
|