Closing the current focused sheet
 

Hi all,

On my excel sheet i have a button ,i want that when this button is clicked
the excel sheet closes,but i don't want this action to close any other open
sheet.

Regards

Closing the current focused sheet
 

Pietro:
Click on FORMAT across the top
Expand the dropdown list to show entire list
Click on SHEET then click on HIDE
to bring it back follow the procedure and click on UNHIDE

"Pietro" wrote:

Hi all,

On my excel sheet i have a button ,i want that when this button is clicked
the excel sheet closes,but i don't want this action to close any other open
sheet.

Regards

Closing the current focused sheet
 

You can't close sheets, only workbooks. adding this insttructtion to a macro
will do what you want

ThisWorkbook.Close

"Pietro" wrote:

Hi all,

On my excel sheet i have a button ,i want that when this button is clicked
the excel sheet closes,but i don't want this action to close any other open
sheet.

Regards

Closing the current focused sheet
 

Thanks a lot,
you got me well

"Joel" wrote:

You can't close sheets, only workbooks. adding this insttructtion to a macro
will do what you want

ThisWorkbook.Close

"Pietro" wrote:

Hi all,

On my excel sheet i have a button ,i want that when this button is clicked
the excel sheet closes,but i don't want this action to close any other open
sheet.

Regards