Display of Excel workbooks

R

Raja Ranga

Hello,

I have a Excel WorkBook 'WrkBook1' containing macros to read values from
Excel workbooks 'WrkBook2', 'WrkBook3' and so on. But when I read the
values, the Excel Workbooks 'WrkBook2', 'WrkBook3' and others will open and
close visually during the reading.

I do not want to see the opening and closing of workbooks while running the
macros. How do I do this?

Any suggestions in this regard will be helpful.

Thank you.
Regards,
Raja Ranga.
 
V

VENKAT

did you try

at the beginning of the macro
application.ScreenUpdating=false
and at the end of the macro add
application.ScreenUpdating=true
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel display problem 3
Unwanted workbooks on startup 2
Workbook_Beforeclose 11
Use Macro to create excel scorecards out of excel workbooks 1
Excel 2013 vlookup to different workbooks not working 5
Macros to extract data frommultiple workbooks to a master workbook 0
Macro -->shared.xls --> .xla add-in --> now not in macro list 7
Multiple workbooks open -- closing workbooks 3

Top