Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Make a normal copy and delete the linked object
HTH Peter
Maybe you want to have an alternate state :
Thank you Oleg for such quick response. I was able to unlink the objects following your instructions.
Thanks Peter.
This method also works.