| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SURROUND DATA WITH COLORFUL MARCHING ANTS | Excel Discussion (Misc queries) | |||
| Turn off selection marching ants in Excel 2003 | Excel Discussion (Misc queries) | |||
| How to setup "marching ants" border Excel cell? OK in MS Word. | Excel Discussion (Misc queries) | |||
| Excel should include flashing cells/block and marching ants like W | Excel Worksheet Functions | |||
| Marching ants | Excel Programming | |||
Linear Mode
