Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parameters in Forms Buttons - not working in Excel 2002 | Excel Programming | |||
Excel 2002 Not Loading | Excel Discussion (Misc queries) | |||
Loading two forms | Excel Programming | |||
Data Forms in Excel 2002 | Setting up and Configuration of Excel | |||
MDI Forms in Excel 2002 XP | Excel Programming |