+ Reply to Thread
Results 1 to 3 of 3

Hide and Password Protected on Specific Column / Rows

  1. #1
    Registered User
    Join Date
    05-16-2021
    Location
    Singapore
    MS-Off Ver
    2104
    Posts
    1

    Question Hide and Password Protected on Specific Column / Rows

    Hi,
    I am new to this... wondering is there any way to do this...?

    How can i hide sensitive information and at the same time not let anyone view the "specific column" , "row" with password protected.

    Then some columns which are not sensitive information can be viewed by others at the same time.



    Thank you!

  2. #2
    Forum Contributor
    Join Date
    05-03-2021
    Location
    Nashville
    MS-Off Ver
    MS Office 365
    Posts
    184

    Re: Hide and Password Protected on Specific Column / Rows

    I don't think there is a way to password protect a specific row or column in the way you are asking.

    you can password protect an entire worksheet and make specific rows and columns "editable".
    There are several approaches to this.

    You can make the entire row and/or column you don't want seen contain "white text".
    Then make all rows and columns editable except the "white text" rows/columns.

    The other option is password protecting a VBA (so you cannot see the VBA code without the password) and create all the columns and rows you don't want seen on a separate tab (call it "Secret Tab" if you want) and then Sheets("Secret Tab").Visible = xlSheetVeryHidden

    They will not be able to unhide the sheet without knowing the password to the workbook.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Hide and Password Protected on Specific Column / Rows

    .
    Here is a sample macro that locks Rows 1:14 and Cols A:E,H:H,K:T,CN:CS,CV:CW

    Edit as required.




    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count up from specific row, instead of end: to Hide rows with 'X' in column B
    By BeeJayII in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2021, 06:48 PM
  2. Replies: 1
    Last Post: 09-22-2020, 10:37 PM
  3. Replies: 1
    Last Post: 04-06-2017, 03:11 PM
  4. Password Macro to view/hide specific tabs and rows
    By mkless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2016, 01:35 PM
  5. password protected hide sheet not work properle
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-30-2013, 09:40 AM
  6. Macro to Hide Rows in Protected Rheet and Re-Apply Password
    By arg1229 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2012, 12:28 AM
  7. Password protected command button to protect/unprotect and hide/unhide
    By cpercival in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2011, 03:27 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1