Hiding a tab

[goofy78270]

I am trying to hide a tab within a workbook but it is giving me an error because I am using a macro to copy information for this sheet from another book. How can I unhide and then hide the sheet within the macro or is there another way to do this?

 

[Norie]

How are you trying to hide the tab?

Code or manually?

If it's via code please post the code.

 

[Domski]

Hi,

I think you'll only get an error if you are trying to select cells on the hidden sheet which is almost always unnecessary. You should be able to paste information to the sheet without actually selecting the cells.

Dom

 

[goofy78270]

Manually

 

[Norie]

What's the error and how is the macro you mentioned involved?

 

[goofy78270]

I am using a select. How can I get around this?

 

[Domski]

Assuming Sheet2 is the hidden sheet you can do it like this without selecting the cells:

Sub test()

Sheets("Sheet1").Range("A1").Copy

With Sheets("Sheet2")

.Paste Destination:=.Range("A1")

End With

End Sub

Dom

 

[MarkAndrews]

Or

Before the paste sequence

Sheets("Sheetname").visible = true

After paste

Sheets("sheetname").visible = false

???

 

[goofy78270]

This is what I currently have. I am not familiar with the With statement but this is what I currently have. The sheets.visible did not seem to work for me.

Sub PastetoMatrixWorkbook()
    Sheets("Drop-Down Data").Select
    Cells.Select
    Selection.Copy
    ChDir "H:\Secondary\Product Development\Product Matrices"
    Workbooks.Open Filename:="H:\Secondary\Product Development\Product Matrices\Matrix.xls"
Windows("Matrix.xls").Activate
    Sheets("Drop-Down Data").Select
    Cells.Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
Windows("EMPSEC Data").Activate
    Sheets("Matrix Results").Select
    Cells.Select
    Selection.Copy
Windows("Matrix.xls").Activate
    Sheets("Matrix Results").Select
    Cells.Select
    ActiveSheet.Paste

 

[MarkAndrews]

Which is your hidden sheet?