Thread: Need to make sure workbook is open before proceeding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
munchkin munchkin is offline
external usenet poster
  
Posts: 57
Default Need to make sure workbook is open before proceeding
Can you help - Users of my form need to make sure Doc2 is open before running
the macro. If Doc2 is not open I need the macro to stop and a message box to
pop up stating Doc2 is not open.


Application.WindowState = xlMinimized


Range("H2").Select
Selection.Copy


Range("E1").Select
ActiveSheet.Paste

Reply With QuoteReply With Quote