LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Old Music Lover
 
Posts: n/a
Default Restricting Rows

Excel 2000-

Is there a way to allow different users to see only their rows in a
community spreadsheet based on "their" ID being located in a particular
column.

Simple example: 20 rows in sheet. 5 users have 4 rows each in sheet.
Column A has NT User ID for each user. I want each to see only his rows and
NEVER be able to see the others.

I get the user logon from NT so I know who opened and can use VBA code to
apply a filter. But there are some many ways for a user to Unfilter to see
all rows.

Any ideas? I am currently working on a two sheet solutions copying data
back and forth but it is getting complicated.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
REALLY miussing rows in Excel2000 Geoff Lambert Excel Discussion (Misc queries) 2 July 21st 05 03:20 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
Row selections by row # OR by even/odd rows in another spreadsheet Tom Excel Discussion (Misc queries) 0 February 9th 05 04:03 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM


All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"