View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike G - D.C. Mike G - D.C. is offline
external usenet poster
 
Posts: 11
Default Hide Worksheets based on value from Access DB

Hello - I've set up a macro within my Access DB that will feed data into an
unopened Excel Worksheet. One of the values that are pulled from the DB will
always match one of 16 worksheet names contained within the workbook. Is it
possible to hide all of the worksheets with names that don't match the value
that is pulled?

The scenario is as follows:
- Access macro kicks data into worksheet "Chart_Table" within Metric Chart.xls
- Value pushed into F2 of Chart_Table worksheet will always match one of 16
worksheet names within Metric Chart.xls
- Once opened, is it possible to automatically hide all worksheets with
names that don't match the value pushed into "Chart_Table" F2?

Thanks, Mike