system
March 28, 2006, 7:19pm
#1
Is there anyway, we can deactivate LOV’s for all objects in a single click…
instead of going to eacg object one by one.
(i have lot of objects, and i want to keep customized LOV’s only for small number of objects)
Thanks
BOLearner (BOB member since 2005-01-20)
system
March 29, 2006, 12:09am
#2
Is there anyway, we can deactivate LOV’s for all objects in a single click…
instead of going to eacg object one by one.
(i have lot of objects, and i want to keep customized LOV’s only for small number of objects)
Thanks
One click … no, but here is a piece of VBA code that can accomplish what you are after.
Dwayne Hoffpauir (BOB member since 2002-09-19)
system
March 29, 2006, 12:27am
#3
that is simply excellant solution that i have ever seen…
Thank you very much Dwayne…
Last question on this…
i am new to using macro’s…
will it have any disadvantages …or is it fine…
Just curious to know
BOLearner (BOB member since 2005-01-20)
system
March 29, 2006, 3:32pm
#4
that is simply excellant solution that i have ever seen…
Thank you very much Dwayne…
Last question on this…
i am new to using macro’s…
will it have any disadvantages …or is it fine…
Just curious to know
You are quite welcome. I’m glad all these little utilities I build are useful for others, but trust me … I rarely build them for others. It’s usually quite selfish first smile .
Disadvantages? The risk is very low, particularly in this case. It’s basically like someone that clicks VERY fast !!! Designer is left open with the universe changed, but not saved. You can review it before saving / exporting.
Dwayne Hoffpauir (BOB member since 2002-09-19)