| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I email amacro? | Excel Worksheet Functions | |||
| saved worksheet opens in new with macro error report | Excel Worksheet Functions | |||
| Running of Worksheet Change Macro breaks undo functionality. | Excel Discussion (Misc queries) | |||
| Macro add worksheet to workbook automatically | Excel Discussion (Misc queries) | |||
| Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
Linear Mode
