BusinessObjects Board

deactivating of LOV's for all objects

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)

One click … no, but here is a piece of VBA code that can accomplish what you are after.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

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)

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 :rotf: !!! Designer is left open with the universe changed, but not saved. You can review it before saving / exporting.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)