Click here to Skip to main content
15,886,069 members
Home / Discussions / C#
   

C#

 
GeneralRe: How i can istall my first project... Pin
VisualLive21-Apr-09 21:55
VisualLive21-Apr-09 21:55 
GeneralRe: How i can istall my first project... Pin
SeMartens21-Apr-09 23:41
SeMartens21-Apr-09 23:41 
GeneralRe: How i can istall my first project... Pin
VisualLive22-Apr-09 6:00
VisualLive22-Apr-09 6:00 
GeneralRe: How i can istall my first project... Pin
VisualLive6-May-09 15:43
VisualLive6-May-09 15:43 
QuestionClickable Link Pin
satsumatable21-Apr-09 20:31
satsumatable21-Apr-09 20:31 
AnswerRe: Clickable Link Pin
zk11322991721-Apr-09 20:37
zk11322991721-Apr-09 20:37 
Questionhttp://www.codeproject.com/KB/list/treelistview.aspx Pin
hirenkshah21-Apr-09 19:36
hirenkshah21-Apr-09 19:36 
QuestionExcel: change cell color of unprotect sheet using macro. Pin
hirenkshah21-Apr-09 19:15
hirenkshah21-Apr-09 19:15 
Hi,

I am using excel RTD in my project, its work fine,
Using following event (SelectionChange) I am changing color of cell based on data.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

But this spreadsheet must be protected from some of our users from destroying the cells that have formulas or conditional formats.

But if I protect sheet I am not able to change color of cell.

So I want to protect sheet as well as change cell color using macro.

My first thought was to unprotect sheet in the beginning of the code, change colore and then at the end, protect it back down.

But this would mean protecting and unprotect every time that cell change color.

Changing cell color is so fast so I think it is inefficient.

Can you suggest what to do in this scenario.

Thanks
hiren shah

QuestionView PDF file in winform Pin
aldo hexosa21-Apr-09 18:54
professionalaldo hexosa21-Apr-09 18:54 
AnswerRe: View PDF file in winform Pin
Giorgi Dalakishvili21-Apr-09 19:39
mentorGiorgi Dalakishvili21-Apr-09 19:39 
QuestionWriting correct code Pin
Akhilesh Yadav21-Apr-09 18:45
Akhilesh Yadav21-Apr-09 18:45 
AnswerRe: Writing correct code Pin
Perry Holman21-Apr-09 19:30
Perry Holman21-Apr-09 19:30 
GeneralRe: Writing correct code Pin
Akhilesh Yadav21-Apr-09 19:32
Akhilesh Yadav21-Apr-09 19:32 
GeneralRe: Writing correct code Pin
Mycroft Holmes21-Apr-09 20:18
professionalMycroft Holmes21-Apr-09 20:18 
AnswerRe: Writing correct code Pin
Thomas Weller21-Apr-09 20:49
Thomas Weller21-Apr-09 20:49 
AnswerRe: Writing correct code Pin
Luc Pattyn22-Apr-09 4:39
sitebuilderLuc Pattyn22-Apr-09 4:39 
QuestionDatagridView Column Re-ordering Pin
codeprasanna21-Apr-09 18:44
codeprasanna21-Apr-09 18:44 
AnswerRe: DatagridView Column Re-ordering Pin
Mycroft Holmes21-Apr-09 20:16
professionalMycroft Holmes21-Apr-09 20:16 
QuestionFtp Linux Command in .Net Pin
Abdul Rahman Hamidy21-Apr-09 18:02
Abdul Rahman Hamidy21-Apr-09 18:02 
AnswerRe: Ftp Linux Command in .Net Pin
blackjack215023-Apr-09 2:57
blackjack215023-Apr-09 2:57 
QuestionNeed assistance with automatic install application Pin
Robert Madsen21-Apr-09 17:13
professionalRobert Madsen21-Apr-09 17:13 
AnswerRe: Need assistance with automatic install application Pin
Perry Holman21-Apr-09 19:38
Perry Holman21-Apr-09 19:38 
GeneralRe: Need assistance with automatic install application Pin
Robert Madsen24-Apr-09 16:34
professionalRobert Madsen24-Apr-09 16:34 
AnswerRe: Need assistance with automatic install application Pin
Giorgi Dalakishvili21-Apr-09 19:40
mentorGiorgi Dalakishvili21-Apr-09 19:40 
GeneralRe: Need assistance with automatic install application Pin
Robert Madsen24-Apr-09 16:30
professionalRobert Madsen24-Apr-09 16:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.