Thread: How do keep colors from a table in MS Excel intact when pasting?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default How do keep colors from a table in MS Excel intact when pasting?
Do you copy to another workbook with code ?
If you changed the colors in one of the workbooks it is possible that you have this problem

With VBA you can do this to copy the palette to another workbook

Workbooks("Book1.xls").Colors = Workbooks("Book2.xls").Colors

--
Regards Ron de Bruin
http://www.rondebruin.nl



" m wrote in message
...



Reply With QuoteReply With Quote