Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 aarohipatel
		
			aarohipatel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello everyone
I have an application with seven sheets and have few sheet objects linked in all of the sheets. Now, I want to unlink the sheet objects in one of the sheets. Please suggest how to do it.
(Ex: I have a listbox linked in 7 sheets and now I want to unlink the list box in the 7th sheet)
Thanks
 
					
				
		
 Oleg_Troyansky
		
			Oleg_Troyansky
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		For a single object, activate the object, right-click, find LinkedObjects>Unlink THis Object. For multiple objects, highlight all of them (Ctrl-A to activate all) and do the same.
best,
Oleg Troyansky
 
					
				
		
 Oleg_Troyansky
		
			Oleg_Troyansky
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		For a single object, activate the object, right-click, find LinkedObjects>Unlink THis Object. For multiple objects, highlight all of them (Ctrl-A to activate all) and do the same.
best,
Oleg Troyansky
 
					
				
		
 prieper
		
			prieper
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Make a normal copy and delete the linked object
HTH Peter
 berryjulien2
		
			berryjulien2
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Maybe you want to have an alternate state :
 aarohipatel
		
			aarohipatel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you Oleg for such quick response. I was able to unlink the objects following your instructions.
 aarohipatel
		
			aarohipatel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks Peter.
This method also works.
