Hello!
I have seen several threads about saving a custom color scheme for new
spreadsheets and am able to do that without issues. The problem I am
having is that I update and edit a set spreadsheet every morning that is
pulled from an Access report. Is there a way to save the custom colors
so I may continually use them on a spreadsheet sent to me from an
outside source? Every morning I have to add the custom colors used to
coordinate all the information across previous reports. I am currently
using Excel 2013 version.
Thank you in advance for your help!
You could save your color scheme on a template sheet, then import from the set
spreadsheet into your template sheet. (Copy/pasteValues) If you do it once
using the macro recorder you'd be able to repeat later by running the macro.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion