Cannot Hide sheets

  • Hello,


    I have a simple query...


    I am working on a workbook and need to hide some sheets, however if I go to FORMAT - SHEET the 'hide' facility is greyed out. There is no protection on the workbook that I can see and I can hide columns, rows or cells, just not sheets. Why would this be?


    Thanks.

  • Re: Cannot Hide sheets


    another possible reason could be that, if you are at work like me, your system administrator can disable the function. (my macro has bee ndisabled by my system administrator for some strange reason!!)


    Jamie

  • Re: Cannot Hide sheets


    Thanks for the response...


    I have found my problem, the Workbook is protected, so although I can make changes to the worksheets data, formula and VB code, I can't hide worksheets.


    Thanks again.

  • Welcome to the Forum


    Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.


    Also, attach an example of the workbook.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!