Hi all I'm completely lost with why I can't show some worksheets in a macro enabled workbook.
The right click tab options to show or hide worksheets is greyed out, using any sort VBA like Visable, xlVisable, -1 etc throws up the error object doesn't support this method nothing I'm doing seems to allow me to show the worksheets even though they are showing in the VBA project window tree as existing.
As far as I am aware I've blocked out any code references that I had in the modules that referred to the visibility of a sheet, I've removed both the worksheets and workbook protection and re-named the workbook using Save As (even though I know is a bit pointless)
Can anyone offer any solutions or things to check that I'm just not doing as its driving me nuts why something so simple is becoming so difficult and time consuming to the point I'm on the verge of just re-doing the whole workbook again from scratch
(its not even an important workbook just something that was meant to make my life a bit easier)
Thanks for any replies offered.
Paul
The right click tab options to show or hide worksheets is greyed out, using any sort VBA like Visable, xlVisable, -1 etc throws up the error object doesn't support this method nothing I'm doing seems to allow me to show the worksheets even though they are showing in the VBA project window tree as existing.
As far as I am aware I've blocked out any code references that I had in the modules that referred to the visibility of a sheet, I've removed both the worksheets and workbook protection and re-named the workbook using Save As (even though I know is a bit pointless)
Can anyone offer any solutions or things to check that I'm just not doing as its driving me nuts why something so simple is becoming so difficult and time consuming to the point I'm on the verge of just re-doing the whole workbook again from scratch
Thanks for any replies offered.
Paul