| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Sheet to Closed Workbook
Good Morning,
I have a Worksheet in a Book that Im moving to another Workbook (WKB2). Im looking to create a Macro which looks to see if WKB2 is closed. If its closed, I would like to insert the sheet from the first Workbook (WKB1). Since I only want to have it perform the action if the other workbook is closed, is there also a way to create a message to alert the user in the event the workbook is open - - - meaning don't move it in that case? Thanks for your review Roger B. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help...Code to copy sheet from closed workbook | Excel Discussion (Misc queries) | |||
| Consolidation of data from cell in active sheet of closed workbook | Excel Worksheet Functions | |||
| Linking to a closed workbook | Excel Worksheet Functions | |||
| Value from a closed workbook | Excel Discussion (Misc queries) | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Linear Mode
