$$Excel-Macros$$ changing color series of charts

2010-01-16 Thread Jade
Hi Everyone, Does anyone know how to loop through all the charts in an activesheet and change the colors series? Thank you. Jade -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

$$Excel-Macros$$ How to save Macro custom buttons I created

2010-01-16 Thread Markkim
Hi Well, it has happened to me many times.. but I have never thought of seeking a solution for it. Is there anyway to back up the macro buttons that you created on the workbook? I have 20 Macros for my work. I have created buttons and each of these buttons linked to a macro... Every time I ope

Re: $$Excel-Macros$$ How to create a link to other sheets...

2010-01-16 Thread Mark Kim
Sorry I didn't attach an file. hm.. not sure how to attach a file. Hope this is ok.. On Sun, Jan 17, 2010 at 7:50 AM, Mark Kim wrote: > Hi Praveen > > Thanks Million!!! This is exactly what I was looking for.. > > Thanks a lot !!! > > > On Sun, Jan 17, 2010 at 1:35 AM, kvc praveen kumar wrot

Re: $$Excel-Macros$$ How to create a link to other sheets...

2010-01-16 Thread Markkim
Hi Praveen Thanks million!! I looked at the code and modified a bit like this: I created a macro button on the tool bar and when I click the button, it get the value from the active cell and take it to the corresponding transaction in the other sheet. I thought this way it will prevent from acci

Re: $$Excel-Macros$$ How to create a link to other sheets...

2010-01-16 Thread Mark Kim
Hi Praveen Thanks Million!!! This is exactly what I was looking for.. Thanks a lot !!! On Sun, Jan 17, 2010 at 1:35 AM, kvc praveen kumar wrote: > Hi, > > Please find the attached file and let me know if this is what you are > looking for. I used worksheet events to impement the same. > Regards

$$Excel-Macros$$ How to create a link to other sheets...

2010-01-16 Thread Markkim
Hi all Wow.. I didn't know there is a place like this where you can get some help from experts for Excel macro.. It's brilliant.. !! I have been thinking for some time that It would be very useful if I had this feature.. I hope it's possible. I have an excel file which has three sheets. First