Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide or display worksheets based on form | Excel Discussion (Misc queries) | |||
PROBLEM: hide/unhide worksheets based on cell value change | Excel Programming | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Hide/Unhide worksheets based on login? | Excel Programming | |||
Hide Access when macro run from Excel | Excel Programming |