+ Reply to Thread
Results 1 to 9 of 9

Hide Columns based on level of access e.g. if "Read Only" Hide G:G

  1. #1
    Forum Contributor
    Join Date
    04-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    317

    Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    Good day all once again,

    I have a workbook that allows the user certain levels of access, if a user is unknown or defined as "Read only Access" then I need to hide hyperlinks in columns G:G, I am working with the code below & struggling somewhat, please see "this is the section of code I am struggling with" below, as always any advice will be greatly appreciated, thank you all & have a great day - Marco

    Please Login or Register  to view this content.

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    I am re-writing your routine but am struggling to understand as to what you are trying to achieve

    Please Login or Register  to view this content.
    If the worksheet name of the worksheet being protected contains "StartGraphs" hide column G on Sheet2? In other words, hide column G on sheet2 if there is any worksheet in the workbook with the text "StartGraphs" in it's name?

    Please Login or Register  to view this content.
    I guess for read only access you always want to hide column G on Sheet3?
    If you like my contribution click the star icon!

  3. #3
    Forum Contributor
    Join Date
    04-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    317

    Re: Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    Hi OllieB,

    Sorry about the "StartGraphs", this was a remnant of the original code, I have removed this & also tried to restructure the "Hidden" columns code (see below) but still to no avail?

    Please Login or Register  to view this content.
    Update - I have also attached a trimmed copy, the code to hide column "G" in both "Forms" & "Procedures" seems simple but I just don't seem to be able to get it to work? Thanks again for any assistance - Marco
    Attached Files Attached Files
    Last edited by matrixpom; 01-31-2013 at 10:10 PM.

  4. #4
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    Can you try the revised routine in the attached workbook?
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    04-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    317

    Re: Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    Hi OllieB,

    Works perfectly! Thank you so much & have a great weekend! - Marco

  6. #6
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    Thank you for the nice comment along with the rep. Have a good weekend too.

  7. #7
    Registered User
    Join Date
    10-16-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    Hi,

    I just found your formula. About User list in Tab Sheet 3, i cant Unhide it.
    Pls advise how to edit or create new?

  8. #8
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    Hairul,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  9. #9
    Registered User
    Join Date
    10-16-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Hide Columns based on level of access e.g. if "Read Only" Hide G:G

    Quote Originally Posted by arlu1201 View Post
    Hairul,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    Sorry, I will contact/Pm the user directly ..
    Sorry again

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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