Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying hidden pages
Hi
I have a workbook with hidden and unhidden worksheets. I have a macro button on sheet 1 with the following code: Private Sub CommandButton2_Click() Sheets(Array("Sheet2", "Sheet3", "Sheet4", _ "Sheet5", "Sheet6", "Sheet7", "Sheet8", _ "Sheet9")).Copy End Sub This copies all sheets to a new workbook and works fine on my pc at homerunning excel 2000. However, I transferred it to my workbook on my pc at work, running excel 97 and I get a runtime error - it won't copy the unhidden sheets. Is this a shortfall of xl97? if so is there any way of copying hidden sheets in this manner?? -- Thanks! --------- Gareth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not Printing Hidden Pages | Excel Discussion (Misc queries) | |||
Cycle through non-hidden pages only | Excel Discussion (Misc queries) | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
Copying and Pasting from Web Pages | Excel Discussion (Misc queries) | |||
Pages hidden with manual breaks still print | Excel Discussion (Misc queries) |