Thread: Sheet Show
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gordon[_2_] Gordon[_2_] is offline
external usenet poster
 
Posts: 211
Default Sheet Show

Hi.

On sheet1 in column A I have 14 tools listed in A6:A20. In column C6:C20 I
have TRUE or FALSE values which are managed by tick boxes located over column
B. Each tool has a sheet named after it. How can I make it so that if a tool
is designated a TRUE, then the sheet will show, and if a FALSE will keep it
hidden. The tool names are exactly the same as the sheet names...

I've managed this with one sheet but got lost doing more than one.

Any help from anyone seriously clever will be appreciated...

Thanks in advance.

Gordon...