Hi guys.
Here is what Im trying to do:
I have a Excel sheet and I want to copy a certain range from many other workbooks and paste it into my excel sheet.
To get the values I want to copy I have to run a macro in each workbook.
I have most of the code ready and it does what I want.
But there is one problem.
The macro I have to run in the other workbooks automatically opens a Save As box and I cant figure out a way to automatically answer "No" or disable the Save As entirely.
My code opens the correct workbook and then I use this code to run the appropriate macro:
Is there any way to have Excel say "No" to any Save As boxes that appears when running macro 1?Please Login or Register to view this content.
Hopefully you understand what Im talking about here.
Any help would be greatly appreciated
P.S: Unfortunately I cannot post any of the Excel files Im using because of the information they contain.
Bookmarks