Unhide Worksheets (that are being used for macros)

[puck8810]

Hey,
I have 5 tabs on my excel workbook. When I noticed that some of my cells were referring to macros that weren't in my tabs. I was curious to see if I could open the sheets that they are running from. I went into the VBE and saw the sheets that the cells are running off of. Does anyone know how to open the hidden tabs that I can see in VBE but not in the excel platform?

Thanks!

 

[Sidivan]

Format -> Sheet -> Unhide

Then just select the sheet you want to see.

 

[puck8810]

Format -> Sheet -> Unhide

Then just select the sheet you want to see.

That isn't working for me.

It says in Excel that if using VBA Macros that I need to consult the owner of the workbook... Anyone else know?