Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 NavinReddy
		
			NavinReddy
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Dear All,
I attechment my Application please could some one help me
its not working sheet level security password ADMIN
Best Regards,
Niranjan
 
					
				
		
 sujeetsingh
		
			sujeetsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		What do you want?
 
					
				
		
 NavinReddy
		
			NavinReddy
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Sujeet, if i login with user credentials i will see only sheet1 or sheet2 or sheer3 i need to hide the sheets only admin can see all sheets Thanks In Advance Niranjan
 
					
				
		
 jagan
		
			jagan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
See page 17, it could interest you the way they handle sheet security
It is an old document, but interesting
Fabrice
 
					
				
		
 sujeetsingh
		
			sujeetsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
 NavinReddy
		
			NavinReddy
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi jagan , please check the application its not working Regards, Niranjan
 
					
				
		
 jagan
		
			jagan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
It is working,
If you login as A, then you can see both Sheet1 and Sheet2.
If you login as B, then you can see only Sheet1.
If you login as C, then you can see only Sheet2.
If you login as D, then you can see both Sheet1 and Sheet2.
Try like this by login with various user ids and you will find the difference.
Regards,
Jagan.
 
					
				
		
I use the Conditional show within the tab properties with the following..
=lower(OSUSER())='xxx\xxxxxx' or lower(OSUSER())='xxx\yyyyyy'
Works for me.
