troubleshooting Question

Show only custom cell styles in the ribbon (excel 2010).

Avatar of easycapital
easycapitalFlag for Macao asked on
Microsoft OfficeMicrosoft ExcelPCVBA
3 Comments1 Solution81 ViewsLast Modified:
Dear suppport,

I have added customer cell selection in the ribbon.
When I open new excel files or obtain from others a file - I see the custom cell styles shown in attached "PIC1".
I have my own - see attached .xlsx. I can save them in the XLStart folder or another location you suggest. Or a macro etc.
Please advise how to easily only show my cell styles when I am going to work in someone else file. Do I have to load my own cell styles into their file or can I have them showing up in my PC?
If so, how to approach it.

I would prefer not to affect their cell style list, in their workbook. But if I have to, I was thinking:
1. Macro to delete all cells styles (form PIC1 not being used in a specific file), then I can manually "merge" my cell styles into that affect file, by bringing them from my own file.

Please advise.

SkylarExecutive Director

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros