Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Hiding Columns

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike T.
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi: I have several Columns that contain sensitive data. I want to Hide these Columns so that the viewing public will not only see just the Columns intended, but in no way, or back door method can Unhide the hidden Columns I do not want to Protect visible data as there might be a need to change it.

    Mike

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You have a couple of options:

    Move the data to another sheet and hide it - then protect the workbook

    or

    Using VBA set the scrollarea to not allow access to those columns.

    or using code remove the unhide function from all menus. (much mor difficult)

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike T.
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks so far. I don't want to move it to antoher WS and this could start to mess things up.

    First off, can you Hide and then Protect to that they can't recall the Columns?

    Can you probide the exact code regarding your second option.

    Thanks--Mike

Some videos you may like

User Tag List

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
  •