A macro to right click a cell and select a item from the right click menu?

Hi all!

I wonder if it is possible to make a macro that right clicks a cell and then chooses a option from the list?

Thanks!

-A-

Originally Posted by Fotis1991

Hmmmm! You didn't like that!!

This one?

Please Login or Register  to view this content.

I didn't understand this one. I am a noob to VBA
Maybe I need to clarify my problem:
Can a macro be used to perform this action: Select a cell, and right click and choose "Recalculate function"?
macro.jpg

Originally Posted by Fotis1991

Now makes no sense to me. Why do you need such a macro?

It's must be something that i don't understand for sure...

I use PI datalink to collect and show data. In order to collect new data since last time the document was opened I need to manually right click and select "Recalculate...".
I have a document with about 70 cells of this kind. And this take a lot of time
Hope this was understandable.

No ideas? Still got this issue unresolved.

Originally Posted by Izandol

You may try:

Please Login or Register  to view this content.

I get the error message: "Invalid use of property"
Maybe I am typing it wrong? I am a noob in VBA

Originally Posted by Izandol

I can not test without the add-in but the syntax is correct for a control on Cell menu. It is possible that control is added dynamically and does not exist when code runs.

I works It was my mistake, I forgot to choose the actual cell and then run the macro.
But is there any way I can use this code to choose a cell, perform this code, choose the next cell and perform this code and so on?

Originally Posted by Izandol

I can not test without the add-in but the syntax is correct for a control on Cell menu. It is possible that control is added dynamically and does not exist when code runs.

I works It was my mistake, I forgot to choose the actual cell and then run the macro.
But is there any way I can use this code to choose a cell, perform this code, choose the next cell and perform this code and so on?