Hi All-
I have a requirement of writing different set of collection details to different sheets of a workbook which I am doing by looping through the collection.
I am creating a new sheet everytime I am looping through the collection and hence there will be dynamic number of sheets int he workbook.
But these sheets are not formatted and I tried to apply the conditional formatting to all the sheets in the workbook through enabling macros but seems because of my group policies I cannot enable macros by default.
I also could see there is nothing like renaming of existing sheets from the Actions available for Excel VBO. Please can you advise how this was implemented in your projects?