Thread: Sheet Show
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Sheet Show

what kind of tickboxes?

Checkboxes from the Control Toolbox Toolbar or from the Forms Toolbar.

What method did you use to get one to work? (show the code?)

--
Regards,
Tom Ogilvy



"Gordon" wrote:

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...