$$Excel-Macros$$ macro to lock cells

2010-01-07 Thread koi1
Hi. I am a developing a performance appraisal form and want the remaining cells in each row to be locked automatically when i enter a value in one of them. No prior knowledge of macros so any and all help will be greatly appreciated. Thanks. --

Re: Thanks praveen, Dave, Ankur!! Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

2010-01-07 Thread kvc praveen kumar
You are welcome Anish. Will keep up the good Work!! Regards, Praveen On Thu, Jan 7, 2010 at 1:53 PM, Anish Shrivastava anish@gmail.comwrote: Hey Praveen, Thanks a lot Man,, this is what I was looking for now I can select those cells and cut, paste in a new column instead of

RE: $$Excel-Macros$$ Re: Urgent Help Needed!!

2010-01-07 Thread Dave Bonallack
Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty silly when this is a macro group! Regards - Dave. Date: Thu, 7 Jan 2010 12:36:39 +0530 Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! From: pkkara...@gmail.com To: excel-macros@googlegroups.com Hello Anish, Please

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

2010-01-07 Thread Kishor Shinde
hi all plz tell me how do macro On Thu, Jan 7, 2010 at 3:23 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty silly when this is a macro group! Regards - Dave. -- Date: Thu, 7 Jan 2010

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

2010-01-07 Thread kvc praveen kumar
Thanks Dave!! Just Thought Ascii values would do the trick and it worked well. On Thu, Jan 7, 2010 at 3:23 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty silly when this is a macro group! Regards - Dave.

Re: $$Excel-Macros$$ Dropdown

2010-01-07 Thread Dilip Pandey
Dear Doki, Attached solution has been revised as per your needs. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jan 6, 2010 at 11:39 PM, Doki dok...@gmail.com wrote: yes. only

Re: $$Excel-Macros$$ Dropdown

2010-01-07 Thread Saurabh
thanks. can u pls expain me how dis WITH statement work. If u hav any lik den pls send me. Thanks once again On Thu, Jan 7, 2010 at 4:02 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Doki, Attached solution has been revised as per your needs. Thanks. Best Regards, -- DILIP KUMAR

RE: $$Excel-Macros$$ Help needed

2010-01-07 Thread Robinson Boreh
Hi Praveen, Thanks for the effort. I still need to incorporate the count of number of deposits. Regards _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of kvc praveen kumar Sent: Thursday, January 07, 2010 1:19 PM To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help needed

2010-01-07 Thread SUMIT VYAS
check my attachment On Thu, Jan 7, 2010 at 5:53 PM, Alokeshwar Tiwary alokeshwar.tiw...@yahoo.com wrote: See attached, there is a new column 'Range' with a conditional formula. Use the same to categorize in range and then use a pivot table to get required results.

$$Excel-Macros$$ ‘developer reference’ results

2010-01-07 Thread pm_sam
hi all... I have excel 2007 and changed my screen resolution to (bigger) to view the help files. unfortunately with the ‘search scope’ set to ‘developer reference’ the font is tiny but with the other ‘search scopes’ the font is bigger than before. I have changed the ‘font size’ button in the help

$$Excel-Macros$$ Please HELP :-(((((

2010-01-07 Thread Amods Bagwe
Please help me to get solution . Need to split the numbers words using formula not macros. dsasd2323 fssdf34235 sdsefges34 44rrr4 (In ths Alphanumeric value, the numbers words should be separated in different columns)  EG:  123 abc45 tr  OUTPUT Should be 123 45(One cell) abc tr(Another

$$Excel-Macros$$ help required

2010-01-07 Thread ashish koul
hi Can someone please change this code as per my requirement . i want that if i am doing nothing in my workbook its idle lets say for 3 or 4 minutes its should automatically save and close it ...also let me know in which event i have to put the macro workbook open or activate , etc. Const

$$Excel-Macros$$ help required want to add oulook signature with logos in it

2010-01-07 Thread ashish koul
ho to insert outlook signature with logos in email while sending a mil from excel Sub SendWithAtt() Dim olApp As Outlook.Application Dim olMail As MailItem Dim i As Long Dim SigString As String Dim Signature As String Application.ScreenUpdating = False Set olApp =

$$Excel-Macros$$ Bubble Chart

2010-01-07 Thread Keith25252
Does anyone know how to change the shape in a bubble chart? I would like to change the circles to ovals. I am using Excel 2007. Thanks -- -- Some important links for excel users: 1. Follow us in TWITTER for tips