Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter Excel bases on the current user
I need to hide rows in an Excel spredsheet based on who opened it.
How can I get the user ID or login name and how can I use this information to hide rows? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter Excel bases on the current user
You need the network name, so use
environ("UserName") Use like Select Case Environ("UserName") Case "Bob" Rows("1:2").hidden=true Case "Jim" Rows("1:24").hidden=true End Select -- HTH Bob Phillips "Keith H" <Keith wrote in message ... I need to hide rows in an Excel spredsheet based on who opened it. How can I get the user ID or login name and how can I use this information to hide rows? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart bases on user input dates | Charts and Charting in Excel | |||
microsoft excel has not been installed for current user | Excel Discussion (Misc queries) | |||
Filter Excel Pivot, based on user entry form | Excel Discussion (Misc queries) | |||
How do I merge 2 data bases in Excel avoiding duplicate records? | Excel Discussion (Misc queries) | |||
Restrict-Filter-Limit-Validate user input in Excel | Excel Discussion (Misc queries) |