I want to set Excel to "select shapes" instead of cells in the bar - I've tried this:
Call CommandBars("Drawing").Controls("Select Objects").Execute
but it wont compile at all !
How is it done ?
I want to set Excel to "select shapes" instead of cells in the bar - I've tried this:
Call CommandBars("Drawing").Controls("Select Objects").Execute
but it wont compile at all !
How is it done ?
Drop the Call.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Yeah, yeah, ... error 91 Object not set !
It's Excel 2016 Home365 version
All right - I'm only on Excel 2010 and it works fine here.
Perhaps show more of your code.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
There is no more code ... I just want to secure the selection is on SHAPES in the first place.
I place the line in Workbook_Open
Test the attached.
If it errors or doesn't work, in the macro blah, try enabling all the commented-out lines It will try for 5 seconds before giving up.
I'm guessing Excel hasn't fully loaded/isn't quite ready when the original Workbook_Open code was running.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
No Cure no pay !
Nothing happens .... the "Select Objects" is NOT toggled ON
It is here!
Is there any code running anywhere else - for example another event code?
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
No code running anywhere !
I think we are talking past each other - right ?
What I'm looking for is enabling the user to select SHAPES flowting on the worksheet by "lassoing" around them - normaly this will select a bunch of cells UNLESS you have toggled this "Select Objects" in the ribbon/bar !
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
It's simply NOT working
By the way, this is important: Supply links to everywhere you've cross posted this to. It's a rule here and at most other forums including MrExcel.
Why? For your own benefit ultimately, have a careful read of http://www.excelguru.ca/content.php?184
Try this instead:
application.CommandBars.ExecuteMso "ObjectsSelect"
Be as you wish to seem
Nice ... thx, it works nicely !
Just inserted in the Workbook_Open sub !
Oh, not working !
Next time I opened the file I got error
Error.jpg
review msg#12
No solution there, I guess !
???????
I don't get you !