Code Reuse - Logging Actions When a Cell Changes

**webbug08** · 04-28-2009, 01:23 PM

Hi all,

I am trying to use following codes for a add-in utility so that user can enable or disable logging activity for a given workbook.
My problem is to how to add the following code to a new workbook so that "Loginfo" function could be activated. I have tried some application... based commands but it do not seem to be working.

Please Login or Register  to view this content.

Is there is any way to add this code to a new workbook using code or any alternative to this activity?
Complete code is mentioned below.

Thanks,
Webbug

Please Login or Register  to view this content.

**webbug08** · 04-29-2009, 12:53 PM

Look forward for reply guys....

**broro183** · 04-30-2009, 05:58 PM

hi Govind

To prevent any confusion I suggest changing your variables so that they do not use the same names as inbuilt objects in EXcel's VBA object model ie:

Please Login or Register  to view this content.

No promises, but you may find the below useful for guided discovery...
Or, someone with more knowledge may step in & provide a definitive response - fingers crossed!

You may* find useful info on Chip's site to allow this code (in an add-in) to work on any open workbook:
*(I haven't read the entire article)
http://www.cpearson.com/excel/Events.aspx
&
http://www.cpearson.com/excel/AppEvent.aspx

To add the code to another workbook using code have a look at:
http://vba2008.wordpress.com/2008/10...ing-excel-vba/
or some of the links on:
http://vbadud.blogspot.com/2008_10_01_archive.html

hth
Rob

**webbug08** · 05-01-2009, 12:24 AM

Dear Rob,

Thanks for all your help.

Govind

**broro183** · 05-01-2009, 07:50 AM

Thanks for the feedback

I'm not really sure how much help I've been but...

Once you have a working solution, would you be able to post it to this thread?
- It will help any others who review this thread looking for answers to their specific problems.
- I'll be able to learn the technique myself without having to do all the testing ;-)

Thanks
Rob

**webbug08** · 05-01-2009, 02:03 PM

Sure..
I have got a link on this forum
http://www.excelforum.com/excel-prog...in-add-in.html

I am trying to understand this one..I am bit new to programming. It will take me some time to get this done. I will surely put as soon as i finish making it.

Thanks,
Govind