I give up ! How can I deactivate the "select objects" arrow button in VBA?

  • Thread starter Thread starter Marie J-son
  • Start date Start date
M

Marie J-son

I found a interesting thing. My procedure made ERROR sometimes at the spot
where it should set a new printarea range. I couldn't find why, because it
worked sometimes and sometimes not and the syntax was o.k.

But now I saw that if the arrow button you use to select graphics / drawings
with is activated, the printarea line gave error. When it was deactivated,
it's working well.

Now - how do I deactivate this damn button in VBA??? I can't find anything
about it anywhwere..


/Regards
 
I tried to set the state, but it refused.. hmm..
but following works:)

Sub SelObjButtonLifter()
With Application.CommandBars.FindControl(ID:=182)
If .State = msoButtonDown Then .Execute
End With
End Sub


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >


Marie J-son wrote in message
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which textbox am I in? 1
Missing objects in worksheet (e.g. command button) 2
Excel range choose button in VBA form 5
Unable to assign macros to a new button in the current worksheet 1
Run select query from VBA code where criteria comes from a multi select ListBox 2
Here I draw the y axes but how do I get an arrow on top 2
Excel VBA AUtofilter arrow (blue) on wrong column 4
Can I Turn PivotCache Refresh (Calc) off & on in VBA? 1

Back
Top