View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Billigmeier David Billigmeier is offline
external usenet poster
 
Posts: 176
Default Workbook change event when tab color changed?

If I change a tab color, can I create a macro to automatically run and do the
following:
1) pull the tab name that was just changed
2) pull the color index that it was changed to?

What I'm going to do with the above 2 items is then color another cell on a
summary tab to match

Thanks
--
Regards,
Dave