View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davethewelder davethewelder is offline
external usenet poster
 
Posts: 62
Default Macro opens file and hangs in VB editor

Hi, I am running a series of macros to open files filter data, cut and paste
data into other spreadsheets and format the data.
I had listed the macros to run within a controling macro which was working
ok but now when it opens a file it opens the VB editor at the worksheet
object, which is blank, and stops the macro.
Is there a command "on exit got to macro2"?

Sub OpenandsaveasXL()
' delete_15_data
' Open_today_Report15
Report_15_Filter
Copy_to_Sheet2
' Open_today_Report17B
' Report_17B_remove_top_rows
' Open_today_Report10
' Report_10_remove_top_rows
End Sub