Click here to Skip to main content
15,890,512 members
Home / Discussions / COM
   

COM

 
GeneralRe: Install ActiveX Pin
KarstenK26-Apr-09 22:46
mveKarstenK26-Apr-09 22:46 
GeneralRe: Install ActiveX Pin
p_196027-Apr-09 0:49
p_196027-Apr-09 0:49 
QuestionHow to get event on custom menu added in Winword Pin
SNI24-Apr-09 3:27
SNI24-Apr-09 3:27 
QuestionProblem in implementing an interface Pin
MKC00223-Apr-09 21:29
MKC00223-Apr-09 21:29 
QuestionClosing Winword document thru WordAddin creates problem. Pin
SNI22-Apr-09 3:08
SNI22-Apr-09 3:08 
AnswerRe: Closing Winword document thru WordAddin creates problem. Pin
Baltoro22-Apr-09 5:35
Baltoro22-Apr-09 5:35 
GeneralRe: Closing Winword document thru WordAddin creates problem. [modified] Pin
SNI22-Apr-09 17:39
SNI22-Apr-09 17:39 
QuestionExcel: change cell color of unprotect sheet using macro. Pin
hirenkshah21-Apr-09 19:14
hirenkshah21-Apr-09 19:14 
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

QuestionDisabling row in ListBox. Pin
Shaileshvb21-Apr-09 18:10
Shaileshvb21-Apr-09 18:10 
AnswerRe: Disabling row in ListBox. Pin
Sun Rays3-May-09 20:43
Sun Rays3-May-09 20:43 
QuestionHow To Simulate OLE Drag & Drop? Pin
Shuang. Wu20-Apr-09 23:43
Shuang. Wu20-Apr-09 23:43 
AnswerRe: How To Simulate OLE Drag & Drop? Pin
KarstenK26-Apr-09 22:49
mveKarstenK26-Apr-09 22:49 
QuestioniTunes add track to playlist Pin
speakers_8620-Apr-09 15:50
speakers_8620-Apr-09 15:50 
AnswerRe: iTunes add track to playlist Pin
speakers_8620-Apr-09 16:10
speakers_8620-Apr-09 16:10 
Questionfailed accessing COM method after successful cocreateinstance. Pin
rsandeepu20-Apr-09 1:39
rsandeepu20-Apr-09 1:39 
AnswerRe: failed accessing COM method after successful cocreateinstance. Pin
guestcat20-Apr-09 2:30
guestcat20-Apr-09 2:30 
QuestionRe: failed accessing COM method after successful cocreateinstance. Pin
rsandeepu20-Apr-09 23:21
rsandeepu20-Apr-09 23:21 
QuestionRe: failed accessing COM method after successful cocreateinstance. Pin
CPallini20-Apr-09 3:01
mveCPallini20-Apr-09 3:01 
AnswerRe: failed accessing COM method after successful cocreateinstance. Pin
rsandeepu20-Apr-09 3:22
rsandeepu20-Apr-09 3:22 
GeneralRe: failed accessing COM method after successful cocreateinstance. Pin
guestcat21-Apr-09 11:00
guestcat21-Apr-09 11:00 
QuestionRe: failed accessing COM method after successful cocreateinstance. Pin
rsandeepu21-Apr-09 15:45
rsandeepu21-Apr-09 15:45 
QuestionRe: failed accessing COM method after successful cocreateinstance. Pin
rsandeepu21-Apr-09 20:47
rsandeepu21-Apr-09 20:47 
AnswerRe: failed accessing COM method after successful cocreateinstance. Pin
KarstenK21-Apr-09 21:18
mveKarstenK21-Apr-09 21:18 
AnswerRe: failed accessing COM method after successful cocreateinstance. Pin
rsandeepu24-Apr-09 2:14
rsandeepu24-Apr-09 2:14 
QuestionAccess to managed constructor with parameters from unmanaged code. Pin
fenrirjk219-Apr-09 23:32
fenrirjk219-Apr-09 23:32 

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.