View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
 
Posts: 267
Default Conditional Tab Colors

Hi -

I'd like a short procedure to loop through a set number of worksheets
(named 1 to 31), testing for the existence of ANY data in cell D3 (on
each sheet) ... if NO DATA exists, the tab color should be changed to
Red.

This procedure will be used on computers running XP and XL02 ...

Any help is greatly appreciated!

Thanks,
Ray