$$Excel-Macros$$ How to kepp some cell Protected in a particular sheet

2008-11-24 Thread vaibhav joshi
hello everybody is it possible to keep few cell in a woksheet protected with password without alteration of that particular cell,because i dont want to protect entire sheet with password pls revert on the same Regards VAibhav Joshi --~--~-~--~~~---~--~~ Visit th

$$Excel-Macros$$ Re: EXCEL / VBA BOOK REQU

2008-11-24 Thread Sunita Paudel
*Hi All,* *Yeah I need that too..if anybdy can send it wud b vry grateful* *thnx* On 11/24/08, M, Madhu : Barclays Finance <[EMAIL PROTECTED]> wrote: > > Dear All, > > > > Pls any bade having the excel /vba books > > Pls sent to my mail id > > > > Kindly do need full > > > > > > *Thanki

$$Excel-Macros$$ Re: How to generate a blank cell

2008-11-24 Thread Dave Bonallack
Hi Gene, You can not create a truly blank cell using worksheet functions. Unfortunately, the only way to do that. is with code. However, won't truly blank cells also be considered as zero by the cdhart/graph? Regards - Dave> Date: Mon, 24 Nov 2008 12:52:54 -0800> Subject: $$Excel-Macros$$ How to

$$Excel-Macros$$ Fwd: Abt macro

2008-11-24 Thread Sunita Paudel
m shocked this type of ppl also here in this group !! -- Forwarded message -- From: Sunita Paudel <[EMAIL PROTECTED]> Date: Nov 18, 2008 9:20 AM Subject: Re: Abt macro To: Sharad Sharma <[EMAIL PROTECTED]> *R U INSANE ??* On Mon, Nov 17, 2008 at 8:29 PM, Sharad Sharma <[EMAIL

$$Excel-Macros$$ How to generate a blank cell

2008-11-24 Thread Gen
Hi everyone, I am doing automatic graph with MS excel, and encounter the following problem. I used a formula to relink the data and doing some calculations at the same cell, so if the calculation returns an error, it will be automatically return a "" or a " " to make the spreadsheet clean. The p

$$Excel-Macros$$ Re: How to Convert Excel Marco to Excel Add Ins (XLA)

2008-11-24 Thread Tom Jeffries
To create an Excel add-in file, follow these steps: 1. Load the workbook that is destined to become your add-in. 2. Start the Visual Basic Editor by pressing *A**LT**+11*. 3. At the very top of the Project window, select the bold entry that declares the name of the VBA project that is

$$Excel-Macros$$ for Removing Macro's Password

2008-11-24 Thread Nagendra Modupalli
Dear Friends, Can please any one send me the tool or software for Removing Password from VBA.Thanks in advance. I have created one macro and i buried password.Please help on same. -- Thanks&Regards Nagendra.M "LIFE IS TO LIVEE"... --~--~-~--~~~--

$$Excel-Macros$$ VB Book

2008-11-24 Thread Nagendra Modupalli
Dear Friends, Can please send me the VB Book on my e-mail id please.Thanks in advance. -- Thanks&Regards Nagendra.M "LIFE IS TO LIVEE"... --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.

$$Excel-Macros$$ Re: Excel File & VBA Password Remover Tool Required

2008-11-24 Thread suresh k
Hope ayush Jain can help in this query. On Mon, Nov 24, 2008 at 11:32 AM, kamlesh jain <[EMAIL PROTECTED]> wrote: > Dear All, > > Can any body send me Tool / Software for Removing Password from Excel > & VBA. > It will be great help for me. > > Thanks in advance. > > -- > Regards, > Kamlesh Jain

$$Excel-Macros$$ Re: How to Convert Excel Marco to Excel Add Ins (XLA)

2008-11-24 Thread Paul Schreiner
Actually, an Excel Add-In is (.xla) You should just be able to use the menu: File-Save As. Then select the file type for Excel Add-Ins: .xla or .xlam in Excel2007. HTH, Paul From: kamlesh jain <[EMAIL PROTECTED]> To: excel-macros@googlegroups.com Sent: Monda

$$Excel-Macros$$ Re: Worked hour difference calculation

2008-11-24 Thread Naveen
Hi,   U can use DAYS360 formula     Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :[EMAIL PROTECTED]   Best Wishes-Karunaada Kuvara --- On Sun, 11/23/08, Norman <[EMAIL PROTECTED]> wrote: From: Norman <[EMAIL PROTECTED]> Subject: $$Exce

$$Excel-Macros$$ EXCEL / VBA BOOK REQU

2008-11-24 Thread M, Madhu : Barclays Finance
Dear All, Pls any bade having the excel /vba books Pls sent to my mail id Kindly do need full Thanking You, Madhu Bangalore HUB Cell : 91-9743130534 This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or

$$Excel-Macros$$ Re: Need some help on the attached file

2008-11-24 Thread Gaurav Kapoor
I did that but in the pivot I need the subtotal for all.Can you help me in that because I was not able to do it. Gaurav K On Sun, Nov 23, 2008 at 8:18 PM, sarfaraz ahmed <[EMAIL PROTECTED]> wrote: > Prasanna is right... Pivot will solve your problem > Regards, > sarfaraz Ahmed > http://findsarfa

$$Excel-Macros$$ Re: Attedance format

2008-11-24 Thread Ajay Varshney
Check the named ranges and vlookup formulas,etc. there are many things wrong in your file. On Sun, Nov 16, 2008 at 10:17 AM, rajesh mishra <[EMAIL PROTECTED] > wrote: > Dear Sir, > > I am working with in factory there two shift working.I Attached the sheet > with mail.Kindly give me prorper solut

$$Excel-Macros$$ Excel File & VBA Password Remover Tool Required

2008-11-24 Thread kamlesh jain
Dear All, Can any body send me Tool / Software for Removing Password from Excel & VBA. It will be great help for me. Thanks in advance. -- Regards, Kamlesh Jain --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot

$$Excel-Macros$$ How to Convert Excel Marco to Excel Add Ins (XLA)

2008-11-24 Thread kamlesh jain
Dear All, Can any one help me How to convert excel macro to Excel Add Ins (.XLS) Thanks in Advance, Regards, Kamlesh --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email

$$Excel-Macros$$ Alternate formula to Goal Seek

2008-11-24 Thread SINGHAL, ATUL.
Hi All, Can any tell me any formula which can return the input required to get a specific output just like Goal Seek do. I want to do this with the help of a formula as Goal Seek requires manual intervention. Sheet is attached for your reference. Lots of thanks in advance. Regards CA. Atul Singh

$$Excel-Macros$$ Re: Code Execution Has Been Interrupted Message

2008-11-24 Thread Ajay Varshney
Need to seee your code before telling you anything about the mistake On Tue, Nov 18, 2008 at 1:53 AM, <[EMAIL PROTECTED]> wrote: > > I have a macro that is running a stored procedure in the back ground > and then going on to the next sheet and repeating. The macro works > fine when step thru it,

$$Excel-Macros$$ Re: devide column values into two columns

2008-11-24 Thread Ajay Varshney
Use text to columns: Steps: Select the data, click on "Data" in menu bar, then click on "Text to Columns", Choose "Delimited", Click "Next", Check "Comma", click "Next", Click "Finish" Done On Wed, Nov 19, 2008 at 8:43 PM, Mike <[EMAIL PROTECTED]> wrote: > > Hi, > i have a data populated into a