Here are a couple:

It'll fail if the workbook's structure is protected
(tools|Protection|protect workbook|check structure)

It'll fail if that's the only visible worksheet in the workbook.

The code tries to hide a worksheet by name and there is no worksheet by that
name (the user renamed/deleted it).



colmkav wrote:

Please can someone answer this question I got at an interview?

What might be a reason why code to make a worksheet hidden might not
work?

--

Dave Peterson