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
|