Application or object defined error
-
- 5StarLounger
- Posts: 1169
- Joined: 08 Jul 2016, 18:53
Re: Application or object defined error
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.
-
- Administrator
- Posts: 76686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Application or object defined error
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.
- 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.
Regards,
Hans
Hans
-
- 5StarLounger
- Posts: 1169
- Joined: 08 Jul 2016, 18:53
Re: Application or object defined error
How can I code in a stop on the workbook_open macro?
-
- Administrator
- Posts: 76686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 5StarLounger
- Posts: 1169
- Joined: 08 Jul 2016, 18:53
Re: Application or object defined error
I get a cannot insert object error.
-
- Administrator
- Posts: 76686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Application or object defined error
Does the attached workbook work for you? I replaced the ActiveX buttons with Form buttons.
You do not have the required permissions to view the files attached to this post.
Regards,
Hans
Hans
-
- 5StarLounger
- Posts: 1169
- Joined: 08 Jul 2016, 18:53
Re: Application or object defined error
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
Thanks
-
- Administrator
- Posts: 76686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Application or object defined error
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.
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.
Regards,
Hans
Hans
-
- 5StarLounger
- Posts: 1169
- Joined: 08 Jul 2016, 18:53
Re: Application or object defined error
First method doesn't work, same behavior as I described earlier.HansV wrote: ↑23 Dec 2021, 23:50Right-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.
Second works but not what I wanted: same height, same left.
None the less, I appreciate our time.
Thanks
-
- Administrator
- Posts: 76686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Application or object defined error
Once you have selected the shapes, you can arrange them. See here
Regards,
Hans
Hans