Application or object defined error

bknight
BronzeLounger
Posts: 1353
Joined: 08 Jul 2016, 18:53

Re: Application or object defined error

Post by bknight »

Going back on the days events, I selected the trust center, external data to enable, switched back to prompt That spreadsheet worked yesterday or the day before. I'll try that and that didn't work.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Application or object defined error

Post by HansV »

You could try the following:
- If necessary, switch to Design Mode on the Developer tab of the ribbon.
- Select each of the command buttons in turn, note their names and captions, then delete them.
- Create new command buttons from the ActiveX Controls section of the Insert dropdown.
- Assign the old names to each of the buttons, and set their captions (click Properties to see all properties, including Caption).
- Save and close the workbook.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1353
Joined: 08 Jul 2016, 18:53

Re: Application or object defined error

Post by bknight »

How can I code in a stop on the workbook_open macro?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Application or object defined error

Post by HansV »

Insert a line with the single word Stop
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1353
Joined: 08 Jul 2016, 18:53

Re: Application or object defined error

Post by bknight »

I get a cannot insert object error.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Application or object defined error

Post by HansV »

Does the attached workbook work for you? I replaced the ActiveX buttons with Form buttons.

TradestationPositions.xlsm
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1353
Joined: 08 Jul 2016, 18:53

Re: Application or object defined error

Post by bknight »

Yes, that works. It used to be possible to group objects but that doesn't seem to be possible right clicking on items holding the shift or ctrl does group objects. If it is not possible, Just thanks.
Thanks

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Application or object defined error

Post by HansV »

Right-click on a button to select it.
Hold down Ctrl or Shift and right-click on another button to select it too.

Alternatively, on the Home tab of the ribbon, in the Editing group, click Find & Select > Select Objects.
You can then hold down Ctrl or Shift and left-click on buttons to select them.
Do not forget to turn off Select Objects when you're done.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1353
Joined: 08 Jul 2016, 18:53

Re: Application or object defined error

Post by bknight »

HansV wrote:
23 Dec 2021, 23:50
Right-click on a button to select it.
Hold down Ctrl or Shift and right-click on another button to select it too.

Alternatively, on the Home tab of the ribbon, in the Editing group, click Find & Select > Select Objects.
You can then hold down Ctrl or Shift and left-click on buttons to select them.
Do not forget to turn off Select Objects when you're done.
First method doesn't work, same behavior as I described earlier.
Second works but not what I wanted: same height, same left.
None the less, I appreciate our time.
Thanks

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Application or object defined error

Post by HansV »

Once you have selected the shapes, you can arrange them. See here
Best wishes,
Hans