Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Change color on active cell

Hi there,

I'm planning to protect my sheet and only allow the user to access some
cells. I'm wondering if there is a way to change the color of the cell as
it becomes active (when for instance clicking on it, or using the Tab key)
so that the user easily can see where he/she's at?

Thanks,

Helen


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default Change color on active cell

Hi Helen,

See Chip Pearson at:

http://www.cpearson.com/excel/RowLiner.htm

---
Regards,
Norman



"Helen" wrote in message
...
Hi there,

I'm planning to protect my sheet and only allow the user to access some
cells. I'm wondering if there is a way to change the color of the cell as
it becomes active (when for instance clicking on it, or using the Tab key)
so that the user easily can see where he/she's at?

Thanks,

Helen



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
how to i change the active cell highlight color? jkk771 Excel Discussion (Misc queries) 1 February 13th 09 04:31 PM
how do I change color of "active" cell to differentiate from rest devildog97 Excel Discussion (Misc queries) 9 May 1st 08 03:25 PM
when I activate a cell i change color of active row & header from HITMAN2 Excel Worksheet Functions 2 April 12th 08 06:33 PM
How to change the active cell outline indicator color in Excel? YoYo74 Excel Discussion (Misc queries) 2 January 11th 06 02:37 PM
How do I change color of active cell in Excel lfletcher Excel Discussion (Misc queries) 4 April 4th 05 06:29 PM


All times are GMT +1. The time now is 12:23 PM.

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

About Us

"It's about Microsoft Excel"