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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and loading forms (Excel 2002)
I wonder what the setting is for Automation security on your system. I've
not used 2002 with VBA, so don't know if it's similar to 2003/2007 or not. HTH, Barb Reinhardt "Andy C" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and loading forms (Excel 2002)
How would I find that out? Macro security is set to low btw.
"Barb Reinhardt" wrote: I wonder what the setting is for Automation security on your system. I've not used 2002 with VBA, so don't know if it's similar to 2003/2007 or not. HTH, Barb Reinhardt "Andy C" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and loading forms (Excel 2002)
That's what I was asking. You are opening the file as read only. What
happens if you don't do that? "Andy C" wrote: How would I find that out? Macro security is set to low btw. "Barb Reinhardt" wrote: I wonder what the setting is for Automation security on your system. I've not used 2002 with VBA, so don't know if it's similar to 2003/2007 or not. HTH, Barb Reinhardt "Andy C" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and loading forms (Excel 2002)
There's no difference. There's still no buttons on the opened worksheet and
the form doesn't appear in the solution explorer. "Barb Reinhardt" wrote: That's what I was asking. You are opening the file as read only. What happens if you don't do that? "Andy C" wrote: How would I find that out? Macro security is set to low btw. "Barb Reinhardt" wrote: I wonder what the setting is for Automation security on your system. I've not used 2002 with VBA, so don't know if it's similar to 2003/2007 or not. HTH, Barb Reinhardt "Andy C" wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and loading forms (Excel 2002)
And everythign works fine if you open it on it's own?
"Andy C" wrote: There's no difference. There's still no buttons on the opened worksheet and the form doesn't appear in the solution explorer. "Barb Reinhardt" wrote: That's what I was asking. You are opening the file as read only. What happens if you don't do that? "Andy C" wrote: How would I find that out? Macro security is set to low btw. "Barb Reinhardt" wrote: I wonder what the setting is for Automation security on your system. I've not used 2002 with VBA, so don't know if it's similar to 2003/2007 or not. HTH, Barb Reinhardt "Andy C" wrote: 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 |
Reply |
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 |