I want all newly opened tabs to have the same format. (Specifically, I want certain columns to have certain background colors and column titles). Is there a way to make all newly opened tabs look like that?
I want all newly opened tabs to have the same format. (Specifically, I want certain columns to have certain background colors and column titles). Is there a way to make all newly opened tabs look like that?
Is this to be a global format for all workbooks or are you only interested in one workbook?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
It's just for one workbook.
Just create a template page and put it on the back end of the tabs, and whenever needed just right click and copy the template for a new page
I believe that you can do this with the Workbook_NewSheet event. If you are looking for someone here to provide you with some code for that you will need to define the characteristics that you want to apply to each new sheet.
Sample attached
Last edited by alansidman; 09-28-2018 at 03:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks