View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin Parker[_2_] Martin Parker[_2_] is offline
external usenet poster
 
Posts: 14
Default Populating combox with worksheet names

Hi

I'm using the following to populate a combobox on a worksheet with the names
of all the worksheets in the workbook:-

Dim ws As Integer
With frmMenu.cbStartUpWorksheet
For ws = 1 To Sheets.Count
..AddItem Sheets(ws).Name
Next
End With

My question is I have one worksheet that is veryhidden and I dont want it to
show in the combobox. How do I do this?

Cheers