Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Views based on sheet name
I have a workbook with approx 17 pages. Each page has 3 custom views. The
views use the sheet name followed by Summary, Detail or Both ie.. ProductSummary, ProductDetail or ProductBoth. I also have a dialog box that allows the user to select their view ActiveWorkbook.CustomViews("ProductSummary").Show but setting up a macro for each view for each page is getting very tedious. Is it possible to use one macro that will insert the name of the active sheet if they push a button named Summary so there isn't a macro for each page? I'm thinking something like ActiveWorkbook.CustomViews("Active.Worksheet"Summa ry).Show but this doesn't appear to work...... Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet protection AND custom views | Excel Discussion (Misc queries) | |||
Hiding columns, custom views, protected sheet | Excel Discussion (Misc queries) | |||
PROTECT SHEET AND SEE MY CUSTOM VIEWS | Excel Worksheet Functions | |||
Custom Views based on sheet name | Excel Programming | |||
Protect sheet while enabling outlines and custom views | Excel Programming |