Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Handle Chart Sheets
i have a code where it populates all the sheet name in a combo
box .. but i get an error when any workbook has chartsheets. i need to modify this code snippet in such a way that it has to populate even chart sheets object name in a combo box if not atleast igonore chart sheets object name ...... For Each wks In ActiveWorkbook.Sheets If wks.Visible = xlSheetVisible Then ctrl.AddItem wks.name End If Next wks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Handle Chart Sheets
By Declaring Wks as Object I can certainly avoid error but chartseet
name are not populated in combooo box . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Handle Chart Sheets
Hi,
For just worksheets use, dim wks as Worksheet For Each wks In ActiveWorkbook.Worksheets If wks.Visible = xlSheetVisible Then ctrl.AddItem wks.name End If Next wks Cheers Andy vicky wrote: i have a code where it populates all the sheet name in a combo box .. but i get an error when any workbook has chartsheets. i need to modify this code snippet in such a way that it has to populate even chart sheets object name in a combo box if not atleast igonore chart sheets object name ...... For Each wks In ActiveWorkbook.Sheets If wks.Visible = xlSheetVisible Then ctrl.AddItem wks.name End If Next wks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Labels and chart sheets | Excel Discussion (Misc queries) | |||
Too Many Headings, Values for Chart Feature To Handle??? | Charts and Charting in Excel | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Referencing chart sheets in vba | Charts and Charting in Excel | |||
Chart sheets cause data sheets to be blank | Charts and Charting in Excel |