View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger Roger is offline
external usenet poster
 
Posts: 226
Default 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.