Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy hidden worksheet
Hi - trying to modify the below code to copy (ref: Tom Ogilvy) a
hidden worksheet called TEMPLATE but rather than copy to front of the worksheet list trying to enter it 1 sheet in (i.e. after an index page). I have tried changing the Copy Before to Copy After. This places the copied sheet in teh right location but it is copied as a hidden sheet. Sub AddNewSheet() Worksheets("TEMPLATE").Copy Befo=Worksheets(1) Worksheets(1).Visible = xlSheetVisible End Sub Chen anyone help please? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
Copy Worksheet and Exclude Hidden fields | Excel Worksheet Functions | |||
How do I copy a worksheet so that hidden columns remain secret? | Excel Discussion (Misc queries) | |||
How do I NOT copy hidden rows to a new worksheet? | Excel Discussion (Misc queries) |