Close worksheet by means of a macro
 

Hi

I need to close a worksheet with a button, so I need a macro to attach.

Thanksing you

Close worksheet by means of a macro
 

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

Close worksheet by means of a macro
 

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

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