Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide or display worksheets based on form Shawnn Excel Discussion (Misc queries) 3 December 31st 08 10:58 PM
PROBLEM: hide/unhide worksheets based on cell value change [email protected] Excel Programming 3 May 31st 06 02:23 PM
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? Marc New Users to Excel 1 March 10th 06 05:10 PM
Hide/Unhide worksheets based on login? jej1216 Excel Programming 2 February 28th 06 03:17 AM
Hide Access when macro run from Excel Snowsride Excel Programming 1 April 6th 05 08:33 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"