Changing the colour of a cell when it is selected?

R

Rizitsu

How does one go about changing the colour of a cell when it i
selected?

i am using hyperlinks between worksheets so that one worksheet doesn
get to clouded with data, when i use a hyperlink and retrieve
worksheet, i want the selected cell. e.g. A1 to become highlighted upo
selection. so that the user knows which cell (text) i am refering to
 
R

Rizitsu

Great.

However, not sure if i am defaulting my expertise to noob by sayin
that, do i need VBA (a Visual Basic IDE) to develop functions in? (o
can i use some other form, plugin, utility, to develop functions fo
excel in?)

I am on a network at work where i am not allowed to install illega
software, or use anything without a license.

Regards

ps. how does one go about accessing the excel newsgroups?

Thanks again
 
D

Dave Peterson

Yes, you will need VBA. But Chip Pearson has an addin at:
http://www.cpearson.com/excel/RowLiner.htm

Chip's addin is not illegal. (It may be fattening, though <vbg>.)

Chip doesn't require a license, but you would have to install on all the pc's.


You can get to the newsgroup via a web based interface at Microsoft's site:
http://www.microsoft.com/communities/newsgroups/default.mspx

or if you can...

Saved from a previous post:

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsoft.public.word.docmanagement
news://msnews.microsoft.com/microsoft.public.word.word97vba
news://msnews.microsoft.com/microsoft.public.word.newusers
news://msnews.microsoft.com/microsoft.public.word.pagelayout
news://msnews.microsoft.com/microsoft.public.word.vba.addins
news://msnews.microsoft.com/microsoft.public.word.vba.beginners
news://msnews.microsoft.com/microsoft.public.word.vba.customization
news://msnews.microsoft.com/microsoft.public.word.vba.general
news://msnews.microsoft.com/microsoft.public.word.vba.userforms
news://msnews.microsoft.com/microsoft.public.word.word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm
 
Top