If anyone can offer an explanation it would be great. I have a number of Sheets in a workbook, five in all, some of which I wish to hide using the xlSheetVeryHidden property. However, when I run my code I get 'Method of select object failed message' I think due to code referencing the sheet. I have the 'EnableSelection' switched to xlNoRestictions could there be any other reason for the message. If I run the code with the sheets visible, no problem.
Hellp!
DaveFish
PS: The cell references place data on the sheet from vba.
Hellp!
DaveFish
PS: The cell references place data on the sheet from vba.