Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook with multiple different views / displays of the sheets
within the file. Most of these pages have deactivate code on the individual sheets. I need to be able to generically copy the visible sheets to a new workbook without taking the code with them. I have tried doing this in an array and can't get it to work, so I am thinking that I need to move it a page at a time. I (personally) could probably make this work by hardcoding the move function to run based upon the selected view, but thought I would see if anyone had a simplier more generic way to select / move the visible sheets. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
Can I copy just the visible sheets? | Excel Discussion (Misc queries) | |||
Copy Visible Sheets into one Workbook | Excel Programming | |||
Copy visible rows with data to new file | Excel Programming | |||
copy sheets to another file | Excel Programming |