Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
swiwthcing between sheets and viewing pages?
I have a macro thata runs on sheet1 of program1.xls. It accesses filenames
on sheet2 of program1.xls and then opens the file name (ie program2.xls) to obtain data and put that data on sheet1 of program1.xls. The program is currently functional. The program however opens all of these different sheets and files and shows me the spreadsheet on each of them as it accesses the data. I would prefer that i only see sheet1 of Program1.xls while this data transfer is taking place. Is there a way to open sheet2 of program1.xls and program2.xls and do the functions that i need to have done while keeping it in the backgroud so i dont have to see this happening? -- dr chuck |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
swiwthcing between sheets and viewing pages?
Application.ScreenUpdating = False
' process workbooks Application.ScreenUpdating = True -- Regards, Tom Ogilvy "dr chuck" wrote in message ... I have a macro thata runs on sheet1 of program1.xls. It accesses filenames on sheet2 of program1.xls and then opens the file name (ie program2.xls) to obtain data and put that data on sheet1 of program1.xls. The program is currently functional. The program however opens all of these different sheets and files and shows me the spreadsheet on each of them as it accesses the data. I would prefer that i only see sheet1 of Program1.xls while this data transfer is taking place. Is there a way to open sheet2 of program1.xls and program2.xls and do the functions that i need to have done while keeping it in the backgroud so i dont have to see this happening? -- dr chuck |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing multiple excel sheets | Excel Discussion (Misc queries) | |||
Viewing Multiple Sheets from Same Workbook | Excel Discussion (Misc queries) | |||
Viewing same cells at the same time in two sheets | Excel Worksheet Functions | |||
Viewing Two Sheets within One Workbook | Excel Discussion (Misc queries) | |||
Viewing Excel sheets on the web | Excel Discussion (Misc queries) |