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.

Br,Cell-styles.xlsx
JPPIC1.png
ASKER CERTIFIED SOLUTION
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