Re: How can we change the background colour for many text boxes at a time?
You would need a routine which runs through all your sheets and objects within a loop and checked if they are (the right) textboxes and then change the properties. Have a look on those both examples from the APIGuide.qvw (in your install folder) how such routine could look like:
function Rand (Lo, Hi)
Rand = Lo + Rnd() * (Hi - Lo + 1) - 0.5
rem ** set random colors in all expression **
rem ** cells in all pivot tables on active sheet. **