Thread: Ignoring code to shut a workbook if it is already shut
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cammy Cammy is offline
external usenet poster
  
Posts: 31
Default Ignoring code to shut a workbook if it is already shut
I have some coding which closes and saves workbooks;
Workbooks("Bund Current Payoff.xls").Close SaveChanges:=True etc

but I want the code not to have an error and have a problem if the file has
already been closed when the code is run.

How do I get around this problem?
Reply With QuoteReply With Quote