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

**matrixpom** · 01-31-2013, 12:27 AM

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.

**OllieB** · 01-31-2013, 04:13 AM

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?

**matrixpom** · 01-31-2013, 05:38 PM

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

**OllieB** · 02-01-2013, 03:25 AM

Can you try the revised routine in the attached workbook?

**matrixpom** · 02-01-2013, 08:29 AM

Hi OllieB,

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

**OllieB** · 02-01-2013, 08:41 AM

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

**Hairul** · 10-16-2013, 05:42 AM

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?

**arlu1201** · 10-16-2013, 05:56 AM

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.

**Hairul** · 10-16-2013, 06:10 AM

Originally Posted by arlu1201

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