Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
is it possible to select different colours for active and inactive sheet objects collectively??
or do we have to do it manually for each sheet object??
You can do it with a macro but it is not worth it making the application heavier with a macro just to change the color.
Hi,
Did you checked the caption tab?
Celambarasan
yes i checked it...
Hi,
In Caption tab specify the Active and Inactive captions of all the objects same color and style, so that whenever an object is inactive it uses the inactive style automatically. There is no need of any macro.
Regards,
Jagan.
You can activate all objects on a sheet with "Ctrl+A" and then set all captions for that sheet at once.