vba - no sheets visible - Macro enabled excel 2007 -

vba - no sheets visible - Macro enabled excel 2007 -

i have workbook inherited has 5 worksheets none of them visible , it's been since got it. i've tried changing sheet properties in vba editor visible (was begin toggled between hidden , visible).

the unhide alternative (in main excel program) isn't available, , arrange alternative isn't available.

i've ran vba hide , unhide sheets , hasn't worked either.

does have other suggestions?

thanks gary

check property visible of worksheets in vba editor. if has value 2 - xlsheetveryhidden, cannot unhide normal excel window. alter -1 - xlsheetvisible.

excel vba