Unhide a Sheet

[lesley burlingham]

I have been sent a excel file for colleagues in Italy, I need to access the images sheet which is only showing in the code. Does anyone know how to make it possible to view this sheet to replace the images.

I have tried right clicking the tabs to unhide, its not there. I can see it in the list of sheets in code. I just cant access it.

Thank in advance

 

[Chihiro]

Chances are, the sheet is set to xlSheetVeryHidden in Properties. There are 2 easy way to show the sheet.

1. In Properties window for the said sheet, find "Visible" setting and change it to xlSheetVisible.

2. Use following code in standard module.

Sub UnhideWS()

Worksheets("Sheet Name").Visible = True

End Sub

 

[lesley burlingham]

Wonderful thank you