VBA copy sheet as hidden

[decadence]

Hi, Is possible to copy a hidden sheet from one workbook to another without unhiding the hidden sheet? I have been looking for a solution to this but can't seem to come up with anything without unhiding, copying then hiding the sheet. Can someone help with this please

 

[RoryA]

No. What's wrong with doing what you describe?

 

[decadence]

Hi RoryA I am trying to copy a master hidden sheet to different workbooks, Nothing is wrong with what I am doing, I was just curious if it could be done

 

[RoryA]

No, you can't copy a hidden sheet.

 

[Jaafar Tribak]

If you just don't want the user to see the hidden sheet, you could Hide the entire workbook, unhide the sheet, copy it , hide the sheet back and then unhide the workbook.

something like this :

Sub Test()
    ThisWorkbook.Windows(1).Visible = False
    Sheet1.Visible = xlSheetVisible
    Sheet1.Copy
    Sheet1.Visible = xlSheetHidden
    ThisWorkbook.Windows(1).Visible = True
End Sub