Results 1 to 9 of 9

Hide column or worksheet permanently ?

This is a discussion on Hide column or worksheet permanently ? within the Excel Questions forums, part of the Question Forums category; Hi, I was wondering whether it is possible to hide a column or row permanently in the sense that a ...

  1. #1
    New Member
    Join Date
    Jul 2002
    Posts
    5

    Default

    Hi,

    I was wondering whether it is possible to hide a column or row permanently in the sense that a user cannot unhide the column or row. Is this also possible with a worksheet ?

    It should basically work as a protection. I have a sheet which I give to users, but they are not allowed to see one specific row/column and one sheet within the workbook. The rest of the workbook is free for reading and editing.

    Do I need VBA or can I stick to an Excel feature ?

    Thanks for your thoughts.

    Regards
    Steve P

  2. #2
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,947

    Default

    WELCOME TO THE BOARD!

    Lock only the cells within the column you wish to hide and unlock the others. If you then protect the sheet, the hidden column cannot be unhidden.
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  3. #3
    New Member
    Join Date
    Jul 2002
    Posts
    5

    Default

    Hi, thanks for your reply.

    Could you please specify a bit more ? I am not sure about locking cells...

    Also how would this work with a worksheet ?

    Thanks for your time.
    Regards
    Steve P

  4. #4
    Board Regular
    Join Date
    Jul 2002
    Posts
    72

    Default

    sheet2.Visible=xlSheetVeryHidden

    This will make sheet2, well, "very" hidden in that the user can not unhide it.

    Unfortunately a column does not seem to have a corresponding "extreme prejudice" sort of property.

    [ This Message was edited by: jemand on 2002-08-11 19:12 ]

  5. #5
    New Member
    Join Date
    Jul 2002
    Posts
    5

    Default

    Thanks Jemand, that works !

    Another suggestion for column or row ?

    Thanks again.

    Steve P

  6. #6
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,947

    Default

    Hey there Steve. Click on cell A1 in your worksheet. Now press CTL + A to select all the cells in your worksheet. With all the cells selected, right click on select FORMAT CELLS. The very last tab that will appear on the pop-up menu is PROTECTION. By default, all cells are LOCKED. This means that once you lock a worksheet, the cells cannot be changed. You want to take the checkmark out of the LOCKED box so that all of the cells are now UNLOCKED. (By the way, the hidden box only means that once the worksheet is locked, the FORMULAS are hidden and cannot be seen in the formula bar.)

    Now you want to click on the column header that you want to protect. This should highlight the entire column. Once again, right click and select FORMAT CELLS. Then from the protection tab you want to LOCK the cells. Now hide the column. Once you have hidden the column, go to the top of the worksheet and select TOOLS......PROTECTION....PROTECT SHEET.

    Did this help?
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  7. #7
    New Member
    Join Date
    Jul 2002
    Posts
    5

    Default

    Yes, this helps and it works beautifully !

    Thanks for your instructions and what a great forum this is !

    Regards
    Steve P

  8. #8
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,947

    Default

    This really is an INCREDIBLE place to turn to if you ever need help. Let me know if I can ever help again.
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  9. #9
    New Member
    Join Date
    Apr 2009
    Location
    Perth, WA
    Posts
    3

    Default Re: Hide column or worksheet permanently ?

    hi,

    i'm trying everything that i have read here and elsewhere and what i have been told by fellow workers but nothing seems to be working to hide specific columns.

    i have unprotected my whole sheet, and just protected the columns i want hidden, protected the sheet, but the columns become visible as soon as columns either side are selected and unhide is clicked or they have been double clicked to stretch to their full potential.

    am i doing something wrong?
    is there another way to hide columns?

    any help?!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com