assign code to avoid the pop up comp-ability check mode save option

[johnodys]

i Have macro sheet to get data split as new workbook but i face problem with saving the worksheet pop-up ,every workbook i have to press enter key i want avoid this popup on this code directly it has to save the file in folder
WHILE run the code the shouldnt ask the save compability check directly process all the file done.




please find the attachment

[jaslake]

Hi John

In your Sub Copy_To_Workbooks() Code add these two indicated lines of Code

Please Login or Register  to view this content.

[johnodys]

Thanks jslake full of knowledge of water in your lake thanks alot

[jaslake]

You're welcome...glad I could help.