LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Different passwords to separate ranges in excel 2000

I want to lock range cells such that only specific users can modif
them. Let's say I've 4 users, I want each user to be able to modif
only a range of cells and be controlled by a password (which can b
asked when the user enters the workbook).

I know this can be acomplished in excel xp, but we've only got exce
2000, so I wanted to do it via code.

Please help with this problem..

--
Message posted from http://www.ExcelForum.com

 
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
Average Ranges of Cells, Return Separate Value for Each Range Eric H Excel Worksheet Functions 5 October 19th 09 04:39 PM
Named ranges prints on separate pages Don Rowley Excel Discussion (Misc queries) 0 January 4th 08 06:15 PM
Can I create Multiple passwords to edit multiple ranges? Conker10382 Excel Discussion (Misc queries) 8 December 31st 06 07:58 PM
2 separate passwords (both valid) to open file regi Excel Discussion (Misc queries) 3 October 2nd 06 04:55 PM
how to select two separate ranges into range object Serge[_2_] Excel Programming 2 October 1st 03 03:10 PM


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

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"