View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy C Andy C is offline
external usenet poster
 
Posts: 4
Default VBA and loading forms (Excel 2002)

Hi,

This has probably been asked before but I can't find it.

When I load a workbook in VBA using:

Dim wb As Workbook
Dim ws As Worksheet

Set wb= Workbooks.Open(filename, False, False)
Set ws= wb.Sheets(1)

None of the command buttons on the called worksheet or UserForms in the
called workbook are available to me. I can't access them and they don't
appear in the Project Explorer. How can I get round this and be able to
access the forms and command buttons in the called workbook when loaded?

Thanks,

Andy C