$$Excel-Macros$$ Unprotect Password of VBA or a excel sheet

2009-03-31 Thread anil kumar
Hello Everyone, I would appricate to all of you, which are associated with this group. this group doing very well in terms of helping in Excel tips. I need a favour from all of you please send me the tool or a file which unprotact the workbook and worsheet and also it will unlock the VBA coding.

$$Excel-Macros$$ Re: doubt

2009-03-31 Thread raafi barey
Thx every1... there are few things in life wch i hav done rght.. joining thz group iz 1 of the few things hehehe Thanks.. Raafi On Tue, Mar 31, 2009 at 6:14 AM, Aindril De wrote: > Hi Raafi, > > Please refer to the following link for the explaination: > http://www.techonthenet.com/excel/q

$$Excel-Macros$$ Re: excel mind of it's own

2009-03-31 Thread cbminfo
On Mar 31, 3:32 pm, rspowell wrote: > Hello Friend -- > > If I'm understanding that you do not want to sort the header (Row 1), > > ... just when you call the Sort dialog in Excel 2003, ensure the > optionbutton control near the bottom labeled 'Header Row' is selected That was just part of the p

Re: [inbox] $$Excel-Macros$$ Re: excel mind of it's own

2009-03-31 Thread Husky
On Tue, 31 Mar 2009 12:32:34 -0700 (PDT), you wrote: > > >Hello Friend -- > >If I'm understanding that you do not want to sort the header (Row 1), > >... just when you call the Sort dialog in Excel 2003, ensure the >optionbutton control near the bottom labeled 'Header Row' is selected >Hope it he

$$Excel-Macros$$ Re: excel mind of it's own

2009-03-31 Thread rspowell
Hello Friend -- If I'm understanding that you do not want to sort the header (Row 1), ... just when you call the Sort dialog in Excel 2003, ensure the optionbutton control near the bottom labeled 'Header Row' is selected If you are working in Excel 2007 - instead it's a checkbox in the upper-r

$$Excel-Macros$$ Re: VBA Help

2009-03-31 Thread Hems
Dear Ashish, i am very much surprised that nobody has solution for this... I really need this for my day-to-day work.Let me know if you have any input on this file. Thank you, Hems On Sat, Mar 28, 2009 at 11:41 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > > -- Forwarded message

$$Excel-Macros$$ Re: doubt

2009-03-31 Thread anil kumar
Hi Dear, This dollar sign indicate the reference. for example A$2 - indicate's Column A with increment with 2,3,4,5 ...n $A2- - indicate's Column A with increment with 2,3,4,5 ...n $A$2 - will fixed the value of a2 cells. Thanks & Regards, Anil Kumar. On 3/31/09, raafi barey wrote: > > Hi..

$$Excel-Macros$$ excel mind of it's own

2009-03-31 Thread cbminfo
There's been no problem for years, it did have this problem once before. But I didn't write the fix down, or lost the fix. This just happened the other day. I suspect it may be onecare related.. onecare is changing all my office security settings to high. And I can't stop it from doing it. So it'

$$Excel-Macros$$ Re: pivot table help

2009-03-31 Thread Harmeet Singh
Mate, That was the only solution I had for your problem if, you wanna use column based data structure. A suggestion for you, get rid of this column based data structure or use SPSS. And most important, the sheet I had sent you can be used for next 17 years (If you are good in mathematics). You ca

$$Excel-Macros$$ Timer function doesn't exist in some workbook ?

2009-03-31 Thread Yu
Hello All, I find a strange phenomena, I can use Timer no problem in some workbooks. But in some workbooks, when I type "Timer" ,it just automatically change to "timer" as a normal variable,not a VBA Function. Do you have any ideas why? Thanks ! Vincent --~--~-~--~~--

$$Excel-Macros$$ Re: pivot table help

2009-03-31 Thread ankur lodha
hi harmeet you dint get my question.. for your type of solution i've to get everything in rows viz. against each date ive to get 10 names then the date changes.. i do not want to remove names from column headings.. please see the file.. that is the original file.. if you could pleas

$$Excel-Macros$$ Look after ur health even ur a computer programmer

2009-03-31 Thread priya
Hi dude's Ur tired o0f working on computer and loos ur health some tips are here Read and make use of it Before that go to this web page * http://mathematicalphysics.webs.com/ * Dieting TipsTo lose weigh

$$Excel-Macros$$ Re: pivot table help

2009-03-31 Thread Prashanth Banneni
Hi, I was looking similar sheet where we can calculate productivity and attendance of individual employee. If any on has information please let me know. Many Thanks, Prashanth On Tue, Mar 31, 2009 at 6:28 AM, Norman May wrote: > Ankur, > > Here is a link to an attendance sheet I made. > I'm n

$$Excel-Macros$$ Re: Losing query definition on external range refresh

2009-03-31 Thread gerozi
Hi Guys, I'm a little surprised no one has any input. If I didn't explain the problem well please let me know as I'm still really curious about what could be causing this issue. Thanks again, Gero On Mar 26, 5:17 pm, gerozi wrote: > Hi all, > > I'm hoping someone can point me in the right dir

$$Excel-Macros$$ Re: doubt

2009-03-31 Thread Manzoor Ahmed
When you drag a formula in excel, it changes refferences ( dragging down changes row refference, the numeric part and dragging horizontally along row changes column refference). $ is meant for not changing the refference, when it is put with row indicator, like A$1, it will not change row 1 while d

$$Excel-Macros$$ Re: amt in words in excel add-in

2009-03-31 Thread harsh shah
*Installation Copy the attached file to the folder where excel stores the add-ins. (To know where excel stores the add-ins, open any workbook, click on Tools - Add-ins - Browse) Then open an excel workbook. Click on Tools - Add-ins - Browse - Give the path to this Addin - Ok* ** NO PASSWORD REQUIR

$$Excel-Macros$$ Fwd: Please let me know the answer to your sample querry. !!!its urgent!!!

2009-03-31 Thread shay shay
Hi All, this question was asked byone of our memgers, wherein as soon an excel opens it has a list of reminders and it shows as a message box to the recent date. Kindly forward me the solution as I am not able to find in my inbox. Regards, Shay --~--~-~--~~~---~--

$$Excel-Macros$$ Re: XML

2009-03-31 Thread satish
Mr. Santosh Bahuguna Thank you very much for your keen interest in helping me in this regard. I would like to make it clear that my requirement is not updating but UPLOADING data in government authorities' website which needs to be done fortnightly. If your suggestion of "WEB BROWSER" control will

$$Excel-Macros$$ Re: pivot table help

2009-03-31 Thread Harmeet Singh
Mate, see attached file. That is self explanatory On Tue, Mar 31, 2009 at 12:12 AM, ankur lodha wrote: > > hi everyone > > i've a task to prepare an attendance register of 10 candidates at my > office.. i'm stuck in pivot table formation.. I'm attaching the sheet for > your perusal.. > > I want

$$Excel-Macros$$ Re: Create Formula to Total Certain Cells

2009-03-31 Thread Harmeet Singh
Attached file has the solution. feel free to revert that doesn't solve issue. On Tue, Mar 31, 2009 at 1:46 AM, StonesFan wrote: > > I have a spreadsheet: > > Account Amount > a.120 100.00 > b.120 50.00 > Tot 120 150.00 > a.220 75.00 > b.220 25.00 >