LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Show/Hide a Secret Cell

Option Explicit
Dim I As Integer
Dim Add As String
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

For I = 1 To 9
Select Case I
Case 1: Add = "$A$1"
Case 2: Add = "$B$1"
Case 3: Add = "$C$1"
Case 4: Add = "$D$1"
Case 5: Add = "$E$1"
Case 6: Add = "$F$1"
Case 7: Add = "$G$1"
Case 8: Add = "$H$1"
Case 9: Add = "$I$1"
End Select
If Target.Address = Add Then
Target.Font.ColorIndex = 1 ' black text
Else
Range(Add).Font.ColorIndex = 15 'grey text
End If
Next I
End Sub


 
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 can I show/hide the cell comment blocks ? raymond New Users to Excel 1 June 19th 09 05:47 PM
show or Hide cell comment when mouse hovers in Excel? Abi Excel Worksheet Functions 1 May 28th 09 05:47 PM
how do I hide the #N/A to not show in the cell Dylan @ UAFC[_2_] Excel Worksheet Functions 1 December 12th 08 01:05 AM
How do you show/hide individual cell gridlines in Excel 2007? Joy Excel Discussion (Misc queries) 2 June 6th 08 04:41 PM
Show/Hide a Secret Cell Hotbird Excel Programming 7 August 12th 03 08:30 PM


All times are GMT +1. The time now is 04:48 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"