$$Excel-Macros$$ A question

2009-12-13 Thread hemant shah
Hi Team Can you pls help me with my question. Every thing is mentioned in the attached sheet. Pls help, Regards, Hemant Shah -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

Re: $$Excel-Macros$$ Alert for repeating cell information

2009-12-13 Thread Dilip Pandey
Agree with Dave, conditional formatting is fast and better way as far as the conditions and resultant color are limited per consideration. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On

Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

2009-12-13 Thread Dilip Pandey
Dear Vinod, There are many demo softwares/ tools available over internet which well help you to remove VBA password. To get the full version, either you can purchase them or search for the unlock key(s) if you get the respective option in tool. Remeber some software do not ask for serial keys.

Re: $$Excel-Macros$$ Freeze the cell once the Data has been entered?

2009-12-13 Thread Dilip Pandey
Dear Ramesh, Required automation is attached herewith. 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 12/10/09, Chanti-Hyderabad ramesh1...@gmail.com wrote: Hi Excel Gurus,

Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

2009-12-13 Thread Vinod N
Dear Dilip, I tried many software... but all asks for a full version i did not fin one which does not ask for a serial key... Please help Thanks Vinod... On Sun, Dec 13, 2009 at 7:14 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Vinod, There are many demo softwares/ tools available

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-13 Thread Zilla
You have to be a premium member to dload that file. On Dec 11, 8:42 pm, Nandkumar kakvipure nandkumar.hindust...@gmail.com wrote: Try Dis one http://rapidshare.com/files/106336650/LostPassword.Passware.Kit.Enter... On Fri, Dec 11, 2009 at 8:02 PM, Abhishek Jain abhishek@gmail.comwrote:

Re: $$Excel-Macros$$ Freeze the cell once the Data has been entered?

2009-12-13 Thread harsh shah
hey this was good one 2009/12/13 Dilip Pandey dilipan...@gmail.com Dear Ramesh, Required automation is attached herewith. Thanks Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062

$$Excel-Macros$$ Rota planning

2009-12-13 Thread Tonto
Dear Group, I am looking to develop a duties rota writing spreeadsheet which creates a table based the rotataion of people but also taking notice of their ability to do either task. In the attached sheet I have listed and numbered all staff and set entry data for the size of the rota and the

$$Excel-Macros$$ Re: A question

2009-12-13 Thread Tonto
http://office.microsoft.com/en-us/templates/CT101172771033.aspx Plenty to go at here to get you started, John On 12 Dec, 18:13, hemant shah hemanthin...@gmail.com wrote: Hi Team Can you pls help me with my question. Every thing is mentioned in the attached sheet. Pls help, Regards,

$$Excel-Macros$$ Convert code into VBA Code

2009-12-13 Thread RK
Hi Friends, how are you all doing. My last post regarding excel based translation from Google when unanswered. I am really hopeful that this time the champs in the group will not disappoint me. I want to convert the below code into a vba code. My requirement is to translate a string from excel

Re: $$Excel-Macros$$ A Simple VBA Query

2009-12-13 Thread Abhishek Jain
Hi folks, Any update ? Regards, On Fri, Dec 11, 2009 at 1:22 PM, Abhishek Jain abhishek@gmail.comwrote: Hi all, Any help on this ? Regards...Abhishek On Tue, Dec 8, 2009 at 8:31 PM, Abhishek Jain abhishek@gmail.comwrote: Hi all, First of all I am very sorry to bother this

$$Excel-Macros$$ Re: Need help to select the data columns into pivot table data field using VBA code.....

2009-12-13 Thread Mathan
Hi Vallinayagam, Thanks a tonne for your help. It's working great. I would like to get more help on this. If data structure changes then I may need to edit the codes according to that. Instead of that input boxes have to get the input from me for column name to use for Row field (e.g. A

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-13 Thread Abhishek Jain
Hi Nandkumar, Well, I downloaded it (as a free user) - two rar files, extracted them, two more rar files, extracted them too - one exe file, VIRUS ALERT ! (glad to know my antivirus works!), exe gone, I deleted rest of the downloaded package. What is it anyway ? Some kind of lost password

RE: $$Excel-Macros$$ A Simple VBA Query

2009-12-13 Thread Dave Bonallack
Hi Abhishek, Attach your workbook, and lets see what you've got so far. Regards - Dave. Date: Mon, 14 Dec 2009 10:23:03 +0530 Subject: Re: $$Excel-Macros$$ A Simple VBA Query From: abhishek@gmail.com To: excel-macros@googlegroups.com Hi folks, Any update ? Regards, On Fri, Dec

$$Excel-Macros$$ Re: Rota planning

2009-12-13 Thread Tonto
Sheet did not attach - where do I do this please? John -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials