Copying hidden worksheets.

[OfficeUser]

Is it possible to copy a hidden worksheet without making it visible? I am trying to keep a particular sheet from ever getting deleted, thus why I use am using a command button to always make a copy of it, but I am trying to always keep it hidden. Thanks.

 

[ogo]

Hi,

You can copy a hidden sheet, but not a veryhidden sheet.

Sheet1.Visible = xlSheetHidden

 

[OfficeUser]

Ok. I was unaware of x1SheetHidden. I will give it a try. But first I am off to learn the differences between the two. Thanks.

 

[OfficeUser]

Well I tried it but have been unsuccessful thus far. Here is the code I am have attached to a command button:

Sheets("Backup").Copy After:=ActiveSheet
    Sheets("Backup (2)").Select
    Sheets("Backup (2)").Name = "Measures"

I changed Sheets("Backup") to your suggested code.

 

[OfficeUser]

Ok, I sorted it out. It is working as intended. User error on my part. Thanks.

 

[ogo]

Hi,

xlsheetveryhidden can't be Unhidden from with Excel you have to unhide it from VBE.

If xlsheetHidden is used, users can unhide it from the excel,

Format>Sheet>Unhide

This is the difference between xlsheetHidden and xlsheetVeryHidden

 

[OfficeUser]

Thanks for the explanation.