'un-select' an object on an Excel worksheet before ending a macro.

[StuCram]

I have a macro that modifies one of 5 objects on an Excel worksheet.
After ending the macro, the object retains its 'handles' as being the selected one.
How can I 'de-select' it while still in the VB macro?

[TMS]

Select a cell on the worksheet. One idea is to save the location of the active cell before you start the macro and then re-select the saved location before you exit the macro.

Please Login or Register  to view this content.

Regards, TMS

[Norie]

Do you need to select the object to work with it?

[StuCram]

Thanks
I was considering that but was wondering if there was some other way.
- Stu

[TMS]

@Norie: good thought

[dlow]

I think that there is "always" an active cell. You cant not have one, but like stated above you dont have to interact with it. You want to limit interaction between VBA & Excel, they are not 2 programs under 1 umbrella but 2 completely different programs that why there is a penalty to select/activate, ect..

[StuCram]

Hi Norie,

Is there a way to do the following without using 'select'?

Please Login or Register  to view this content.

I tried combining the first two lines but got an error.

Please Login or Register  to view this content.

[Norie]

Is btnName a button?

If it is how did you create it?

Can you post the rest of the code so we can see what newStyle, newSize etc are?

[StuCram]

Hi Norie

I'm using Excel 11 on a Mac; the workbook will be used on both Mac & Windows systems.

Heres the full subprogram; the purpose is to set a specified button to have the new characteristics.

Please Login or Register  to view this content.

[mikerickson]

Since its a single button, you don't need to use a shape range or selection

Please Login or Register  to view this content.

[StuCram]

many thanks mikerikson,

That worked perfectly.
I had tried .TextFrame but missed .Characters.

Best wishes,
- Stu