Closing the current focused sheet

P

Pietro

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
 
J

Jocko_MacDuff116

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
 
J

Joel

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

ThisWorkbook.Close
 
P

Pietro

Thanks a lot,
you got me well

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

ThisWorkbook.Close
Click to expand...
 
Top