Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 2nd 19, 10:37 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2019
Posts: 2
Default How to change data validation values based on different passwords

Dear Excel community

I have a problem to resolve asap. I have prepared an excel business case with certain cells having data validation lists. Say I have 12 values in the Validation List picked from a source, but all values are not meant for everyone. I need to create three different users with their respective passwords. First user should be able to see only first 5 values of the list (e.g.) and should be able to select only out of these values. The aecond user should see values 6-9, e.g. and so on.

Appreciate community's kind support.

Cheers

  #2   Report Post  
Old June 2nd 19, 06:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,072
Default How to change data validation values based on different passwords

Dear Excel community

I have a problem to resolve asap. I have prepared an excel business case with
certain cells having data validation lists. Say I have 12 values in the
Validation List picked from a source, but all values are not meant for
everyone. I need to create three different users with their respective
passwords. First user should be able to see only first 5 values of the list
(e.g.) and should be able to select only out of these values. The aecond user
should see values 6-9, e.g. and so on.

Appreciate community's kind support.

Cheers


Use a different sheet for each user and require user-login to use their sheet.
Hide the sheet containing the DV Lists (1 list per user-specific access).

-OR-

Use a login sheet with the respective DV Lists hidden in top rows OR left
columns. This will serve as a 'Splash' panel where users can enter their
credentials to display their sheet.

Optionally, have 1 user-sheet with the DV List and have code edit the DV
dropdowns to match user login credentials.

May seem like a lot of work but (IMO) if it's a reusable business solution that
gets repeated often it's worth designing well; - never had a client who didn't
appreciate a well designed solution!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Old June 3rd 19, 08:46 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2019
Posts: 2
Default How to change data validation values based on different passwords

On Sunday, 2 June 2019 20:22:53 UTC+3, GS wrote:
Dear Excel community

I have a problem to resolve asap. I have prepared an excel business case with
certain cells having data validation lists. Say I have 12 values in the
Validation List picked from a source, but all values are not meant for
everyone. I need to create three different users with their respective
passwords. First user should be able to see only first 5 values of the list
(e.g.) and should be able to select only out of these values. The aecond user
should see values 6-9, e.g. and so on.

Appreciate community's kind support.

Cheers


Use a different sheet for each user and require user-login to use their sheet.
Hide the sheet containing the DV Lists (1 list per user-specific access).

-OR-

Use a login sheet with the respective DV Lists hidden in top rows OR left
columns. This will serve as a 'Splash' panel where users can enter their
credentials to display their sheet.

Optionally, have 1 user-sheet with the DV List and have code edit the DV
dropdowns to match user login credentials.

May seem like a lot of work but (IMO) if it's a reusable business solution that
gets repeated often it's worth designing well; - never had a client who didn't
appreciate a well designed solution!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Many thanks GS and appreciate your time for the post. I prefer login sheet or user-sheet with DV list edited with codes. Unfortunately i am a basic excel user and do not know how to write codes. I would truly appreciate if you could help me with a sample code.

Cheers
  #4   Report Post  
Old June 4th 19, 01:57 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,072
Default How to change data validation values based on different passwords

Download the sample XLS:

https://app.box.com/s/w73vj1bf01dorv65q7fjvwbcttpos124

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
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
custom data validation on cells with data validation values AKrobbins Excel Worksheet Functions 2 June 21st 11 04:20 PM
Data Validation List - Dependant based on numeric values Roady Excel Discussion (Misc queries) 4 February 12th 10 05:39 PM
Data validation list drop-down values based on prior selections David Excel Programming 2 September 26th 08 03:58 PM
data validation, totaling values based off dropdown lists Jesse Blanchard[_2_] Excel Discussion (Misc queries) 5 September 15th 08 05:15 PM
Data Validation based on range of values jej1216 Excel Programming 2 February 28th 06 03:34 AM


All times are GMT +1. The time now is 12:34 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017