Click here to Skip to main content
15,891,943 members
Home / Discussions / C#
   

C#

 
QuestionTramsfer file accross a network Pin
yesu prakash21-Apr-09 21:50
yesu prakash21-Apr-09 21:50 
AnswerRe: Tramsfer file accross a network Pin
Mbah Dhaim21-Apr-09 22:04
Mbah Dhaim21-Apr-09 22:04 
Questionnew in this industry Pin
benson.misi21-Apr-09 21:42
benson.misi21-Apr-09 21:42 
AnswerRe: new in this industry Pin
Mbah Dhaim21-Apr-09 21:58
Mbah Dhaim21-Apr-09 21:58 
QuestionHow to capture the Windows XP backgournd to gray? (.NET Framework 3.0) Pin
CooperWu21-Apr-09 21:16
CooperWu21-Apr-09 21:16 
QuestionHow i can istall my first project... Pin
VisualLive21-Apr-09 21:13
VisualLive21-Apr-09 21:13 
AnswerRe: How i can istall my first project... Pin
SeMartens21-Apr-09 21:27
SeMartens21-Apr-09 21:27 
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 

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.