| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem of moving focused cell by arrow key | Excel Discussion (Misc queries) | |||
| New user with focused direction! Will Excel and VBA do it? | New Users to Excel | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
| Return number of current sheet | Excel Worksheet Functions | |||
| Can't save chart as object in current sheet | Charts and Charting in Excel | |||
Linear Mode
