View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JAD[_3_] JAD[_3_] is offline
external usenet poster
 
Posts: 2
Default Turning Colored Cell's Off

When I design a speadsheet, I use color to designate cells
that are protected from cells that are not. While I prefer
this method, others in the group would prefer a white
background on all worksheets. Is there a way to write a
macro which can toggle between both formats? In the past I
have written a macro that can accomplish this goal, but
required more lines of code since I did not know of a
simple multiple line code that could accomplish the same.
Any help would be appreciated. Thank You, JAD