Moving Sheet to Closed Workbook

R

Roger

Good Morning,

I have a Worksheet in a Book that I’m moving to another Workbook (“WKB2â€).
I’m looking to create a Macro which looks to see if “WKB2†is closed. If
it’s 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top