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

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

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

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

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

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

Yes, the buttons are there and the form appears in solution explorer (and the
buttons display it OK as they are supoosed to).




"Barb Reinhardt" wrote:

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