how to get marching ants in Excel programmatically
 

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to right
click - when user clicks on that menu items then I want to show all the
cells (with marching ants around) that has special data. Is this possible to
do programatically?

Thanks in advance!!

how to get marching ants in Excel programmatically
 

selection.copy

until something happens that clears the clipboard, you should have the marquee

--
Regards,
Tom Ogilvy

"Dev" wrote:

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to right
click - when user clicks on that menu items then I want to show all the
cells (with marching ants around) that has special data. Is this possible to
do programatically?

Thanks in advance!!

how to get marching ants in Excel programmatically
 

but it's not wokring for discontigious cells. I may have my cells which has
special data discontigiously...

"Tom Ogilvy" wrote:

selection.copy

until something happens that clears the clipboard, you should have the marquee

--
Regards,
Tom Ogilvy

"Dev" wrote:

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to right
click - when user clicks on that menu items then I want to show all the
cells (with marching ants around) that has special data. Is this possible to
do programatically?

Thanks in advance!!

how to get marching ants in Excel programmatically
 

I mean if cells are in different worksheet(s)...

"Dev" wrote:

but it's not wokring for discontigious cells. I may have my cells which has
special data discontigiously...

"Tom Ogilvy" wrote:

selection.copy

until something happens that clears the clipboard, you should have the marquee

--
Regards,
Tom Ogilvy

"Dev" wrote:

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to right
click - when user clicks on that menu items then I want to show all the
cells (with marching ants around) that has special data. Is this possible to
do programatically?

Thanks in advance!!

how to get marching ants in Excel programmatically
 

Looks like you are out of luck unless you are willing to program it from
scratch.


maybe blinking cells?

--
Regards,
Tom Ogilvy


"Dev" wrote:

but it's not wokring for discontigious cells. I may have my cells which has
special data discontigiously...

"Tom Ogilvy" wrote:

selection.copy

until something happens that clears the clipboard, you should have the marquee

--
Regards,
Tom Ogilvy

"Dev" wrote:

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to right
click - when user clicks on that menu items then I want to show all the
cells (with marching ants around) that has special data. Is this possible to
do programatically?

Thanks in advance!!

how to get marching ants in Excel programmatically
 

Dev,
You can't show that apart from on the ActiveSheet.

NickHK

"Dev" ...
I mean if cells are in different worksheet(s)...

"Dev" wrote:

but it's not wokring for discontigious cells. I may have my cells which
has
special data discontigiously...

"Tom Ogilvy" wrote:

selection.copy

until something happens that clears the clipboard, you should have the
marquee

--
Regards,
Tom Ogilvy

"Dev" wrote:

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to
right
click - when user clicks on that menu items then I want to show all
the
cells (with marching ants around) that has special data. Is this
possible to
do programatically?

Thanks in advance!!

how to get marching ants in Excel programmatically
 

can we acheive blinking cells for cells across different worksheets? if so,
how to do it? thanks!!

"Tom Ogilvy" wrote:

Looks like you are out of luck unless you are willing to program it from
scratch.


maybe blinking cells?

--
Regards,
Tom Ogilvy


"Dev" wrote:

but it's not wokring for discontigious cells. I may have my cells which has
special data discontigiously...

"Tom Ogilvy" wrote:

selection.copy

until something happens that clears the clipboard, you should have the marquee

--
Regards,
Tom Ogilvy

"Dev" wrote:

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to right
click - when user clicks on that menu items then I want to show all the
cells (with marching ants around) that has special data. Is this possible to
do programatically?

Thanks in advance!!

how to get marching ants in Excel programmatically
 

http://tinyurl.com/gu6p2

there is no reason you couldn't write your code to make cells on other
sheets blink, but I am not sure what purpose it would serve if no one can
see them blinking.


--
Regards,
Tom Ogilvy

"Dev" wrote in message
...
can we acheive blinking cells for cells across different worksheets? if
so,
how to do it? thanks!!

"Tom Ogilvy" wrote:

Looks like you are out of luck unless you are willing to program it from
scratch.


maybe blinking cells?

--
Regards,
Tom Ogilvy


"Dev" wrote:

but it's not wokring for discontigious cells. I may have my cells which
has
special data discontigiously...

"Tom Ogilvy" wrote:

selection.copy

until something happens that clears the clipboard, you should have
the marquee

--
Regards,
Tom Ogilvy

"Dev" wrote:

I am trying to get marching ants in Excel programmatically.

I have some special data in certain cells. I added a menu item to
right
click - when user clicks on that menu items then I want to show
all the
cells (with marching ants around) that has special data. Is this
possible to
do programatically?

Thanks in advance!!