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. |
All times are GMT +1. The time now is 01:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com