Create New Workbooks with Matching TAB Colors

Pratibha Sharma

unread,

Aug 28, 2015, 9:07:50 AM8/28/15

to Excel VBA Lab

Dear Group,

I have 15 Worksheets in One Workbook with Different TAB Colors. I want to create new sheets with the Matching Same TAB Color.

Example : If Sheet 1, 4, 5 have Orange Tab Color then New Workbook will be created with the these Tabs.

Any Idea, How to do it.

Rgds

PS

Ashish Kumar

unread,

Aug 29, 2015, 10:56:08 AM8/29/15

to Excel VBA Lab

Dear Pratibha,

Check this...!

Save this file in Blank Folder and run the macro. All new files are created and save in the same folder.

Regards

Ashish Kumar

Create Workbooks.xlsm

Ashish Bhalara

unread,

Aug 29, 2015, 11:28:39 PM8/29/15

to Excel VBA Lab

Hi, Mr.Ashish Kumar,

You make nice coding to make different workbook on their tab color, thanks to share.

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/baaee9fc-106f-4435-8817-3c21a8218e3a%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Ashish Kumar

unread,

Aug 30, 2015, 2:38:20 AM8/30/15

to Excel VBA Lab

Hi Ashish Bhalara,

Thanks for Acknowledge...!

Regards

Ashish Kumar

Ashu K

unread,

Aug 30, 2015, 12:21:52 PM8/30/15

to Excel VBA Lab

Dear Ashish Sir,

It's Superb. Thanks for sharing.

Thanks & Regards

Ashu Kenith

Reply all

Reply to author

Forward