Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Cell color change on mouse over

Is there any way to make a cell containing link to change color on mouse
over?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Cell color change on mouse over

Hi
this would be very difficult (maybe using aPI calls9. Problem is
there's no mouse_over event on worksheet level

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Is there any way to make a cell containing link to change color on

mouse
over?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Cell color change on mouse over

Thanks Frank. But what is PI calls9. I'm a newbee.
"Frank Kabel" wrote in message
...
Hi
this would be very difficult (maybe using aPI calls9. Problem is
there's no mouse_over event on worksheet level

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Is there any way to make a cell containing link to change color on

mouse
over?





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Cell color change on mouse over

Sorry
should read API calls (Application Programming Interface). That is you
probably have to access directly the Windows API function calls, get
the mouse position from them and then (probably relatively complex)
calculate the cell position under the mouse cursor (taking screen
resultion, zoom factor, etc. into account9

So IMHO not something i would do. Maybe you can explain WHY you're
trying to do this.

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Thanks Frank. But what is PI calls9. I'm a newbee.
"Frank Kabel" wrote in message
...
Hi
this would be very difficult (maybe using aPI calls9. Problem is
there's no mouse_over event on worksheet level

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Is there any way to make a cell containing link to change color

on
mouse
over?






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Cell color change on mouse over

Well, it's not really important but this worksheet is going to have links to
many other pages in a workbook. So I thought it would be nice to make them
work like a hoover button on a web page.Seems like I have to give it up.
Many Thanks.
Igor Sudnik.
"Frank Kabel" wrote in message
...
Sorry
should read API calls (Application Programming Interface). That is you
probably have to access directly the Windows API function calls, get
the mouse position from them and then (probably relatively complex)
calculate the cell position under the mouse cursor (taking screen
resultion, zoom factor, etc. into account9

So IMHO not something i would do. Maybe you can explain WHY you're
trying to do this.

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Thanks Frank. But what is PI calls9. I'm a newbee.
"Frank Kabel" wrote in message
...
Hi
this would be very difficult (maybe using aPI calls9. Problem is
there's no mouse_over event on worksheet level

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Is there any way to make a cell containing link to change color

on
mouse
over?










  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Cell color change on mouse over

Hi
why not insert a hyperlink (Insert - Hyperlink)

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Well, it's not really important but this worksheet is going to have

links to
many other pages in a workbook. So I thought it would be nice to make

them
work like a hoover button on a web page.Seems like I have to give it

up.
Many Thanks.
Igor Sudnik.
"Frank Kabel" wrote in message
...
Sorry
should read API calls (Application Programming Interface). That is

you
probably have to access directly the Windows API function calls,

get
the mouse position from them and then (probably relatively complex)
calculate the cell position under the mouse cursor (taking screen
resultion, zoom factor, etc. into account9

So IMHO not something i would do. Maybe you can explain WHY you're
trying to do this.

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Thanks Frank. But what is PI calls9. I'm a newbee.
"Frank Kabel" wrote in message
...
Hi
this would be very difficult (maybe using aPI calls9. Problem

is
there's no mouse_over event on worksheet level

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Is there any way to make a cell containing link to change

color
on
mouse
over?









  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default Cell color change on mouse over

Hi Igor,
On a web page, I'm more familiar with the tooltip (title=) as seen at the
top of my search.htm webpage than with "cheap effects".

In Excel the tool tip is called a Screen Tip and you can override
the link that would normally be shown by choosing ScreenTip in the
upper right corner of the Edit Hyperlink dialog (Ctrl+K). Not available
form the HYPERLINK Worksheet Function.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Igor Sudnik" wrote in message ...
Well, it's not really important but this worksheet is going to have links to
many other pages in a workbook. So I thought it would be nice to make them
work like a hoover button on a web page.Seems like I have to give it up.
Many Thanks.
Igor Sudnik.
"Frank Kabel" wrote in message
...
Sorry
should read API calls (Application Programming Interface). That is you
probably have to access directly the Windows API function calls, get
the mouse position from them and then (probably relatively complex)
calculate the cell position under the mouse cursor (taking screen
resultion, zoom factor, etc. into account9

So IMHO not something i would do. Maybe you can explain WHY you're
trying to do this.

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Thanks Frank. But what is PI calls9. I'm a newbee.
"Frank Kabel" wrote in message
...
Hi
this would be very difficult (maybe using aPI calls9. Problem is
there's no mouse_over event on worksheet level

--
Regards
Frank Kabel
Frankfurt, Germany

"Igor Sudnik" schrieb im Newsbeitrag
...
Is there any way to make a cell containing link to change color

on
mouse
over?










Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change tab color based on current color of a cell MarkT Excel Discussion (Misc queries) 0 May 22nd 08 05:46 PM
Mouse pointer (arrow) change color? robert morris Excel Discussion (Misc queries) 3 February 14th 08 03:32 PM
Excel: Syntax to change cell color based on color of another cell davew18 Excel Worksheet Functions 1 January 4th 07 01:24 PM
How to change the default Border, Font Color, and Cell Color Elijah Excel Discussion (Misc queries) 3 November 2nd 05 11:52 PM
Can I change the font/shading of a cell by moving the mouse over i Husker87 Excel Worksheet Functions 1 October 25th 05 03:33 PM


All times are GMT +1. The time now is 12:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"