$$Excel-Macros$$ Re: single password for excel

2009-05-11 Thread Dave Bonallack
Oh dear, someone really hasn't been paying attention. Date: Mon, 11 May 2009 11:25:56 +0530 Subject: $$Excel-Macros$$ Re: single password for excel From: rishi.pathak1...@gmail.com To: excel-macros@googlegroups.com Microsoft passwords can not be broken!! With regards Rishi Pathak On Sun, M

$$Excel-Macros$$ Password

2009-05-11 Thread Joe Wilson
Hi everyone. How can I find out the password of a protected sheet? I can't actually break it, but I just need to unlock it to fix something and then re-protect it. Any ideas? --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: single password for excel

2009-05-11 Thread zheng yu
hahaha,thanks Rishi Pathak [?] Hmm.i was just thinking out of box la[?]but now i know some box you just can get out of..it is wild and dangerous outside :-) On Mon, May 11, 2009 at 9:48 AM, Dave Bonallack wrote: > Oh dear, someone really hasn't been paying attention. > > > --

$$Excel-Macros$$ Re: Condtional Formatting - Query

2009-05-11 Thread Fabio Lemos
If you have to format a list you should remove the anchor ("$") for the rows... Lets say you want to format based on column A and you have many rows. Select the entyre range and set a conditional format using the formula: =$A1="Friday" so, each line will be formated depending of the content of

$$Excel-Macros$$ Re: Run a macro on Enter?

2009-05-11 Thread Fabio Lemos
Hi, I found another post with interesting information : http://www.mrexcel.com/forum/showthread.php?t=181654 at.te 2009/5/10 Aindril De > Hi I have been watching this thread for a long time. While doing a little > research on Google. I came up with two links that I thought can help you > guys.

$$Excel-Macros$$ Re: Condtional Formatting - Query

2009-05-11 Thread Harmeet Singh
See attached file On Mon, May 11, 2009 at 8:30 PM, Fabio Lemos wrote: > If you have to format a list you should remove the anchor ("$") for the > rows... > > Lets say you want to format based on column A and you have many rows. > > Select the entyre range and set a conditional format using the f

$$Excel-Macros$$ Re: Password

2009-05-11 Thread Harmeet Singh
open attached file and after that open ur file. press ALT+F8. run macro "PasswordBreaker" Cheers On Mon, May 11, 2009 at 6:44 PM, Joe Wilson wrote: > Hi everyone. How can I find out the password of a protected sheet? > > I can't actually break it, but I just need to unlock it to fix something

$$Excel-Macros$$ Re: Nth Row

2009-05-11 Thread Harmeet Singh
1. Open the file that i have sent u. 2. Open ur file. 3. Select data tab. 4. Press ALT+F8 5. Run macro HHH 6. a sheet will be created named Data and desired data will copied into it. 7. First Delete sheet name data whenever u run this macro. 8. On Sun, May 10, 2009 at

$$Excel-Macros$$ Re: Consolidation of sheets

2009-05-11 Thread Harmeet Singh
Hi Kunal, R u using excel 2007. den it wont work On Sun, May 10, 2009 at 8:17 PM, kunal wrote: > > HI Harmeet, > > The code is giving a Run time error '445' > > the object doesn't support this action. > > the error is in the fllowing line: >With Application.FileSearch > > > Regards, > > Kuna

$$Excel-Macros$$ Macro Help - Print worksheet loop as one print job

2009-05-11 Thread Dustin
Dear All, I have an invoice template, which reads different data from other worksheets in the workbook through a for loop. Each iteration of the loop is a different customer and hence a new invoice. Currently, I am searching for a way to print these invoices (a few hundred) in a single print job,

$$Excel-Macros$$ delete a common word in a column pls help

2009-05-11 Thread subs
hi i have data like this in the column of the excel table total charge: apl total charge:ppg total charge:uia These are the the columns. there are many more columns like them. i want to remove total charge in all the columns headings. i want to keep apl, ppg and uia an

$$Excel-Macros$$ Re: Average's

2009-05-11 Thread Sabbycat
Hello Andy i shall try this and see how it goes if not i shall send you the sheet and see what you think. Thankyou once again for your assitance On May 9, 7:49 pm, Aindril De wrote: > Considering, if you want the average of the top 7 sales and the lowest 7 > sales > > For highest 7 > =AVERAGE(L

$$Excel-Macros$$ F4 Repeat No Longer Available in Excel 2007

2009-05-11 Thread Rene Resendez
I use to be able to just about use F4 to repeat the last command in Excel 2003, my company just upgraded to Excel 2007. Now that function is longer available. Does anyone have any possible solutions. Thanks in advance to anyone who can help. --~--~-~--~~~---~--~

$$Excel-Macros$$ i cannot write with E , for example 11E17

2009-05-11 Thread 2008ra...@gmail.com
Hi I have a problem with my goods's code.my goods's code is that bellow codes and that codes make a problem with Excel when i take report from my database.. In database ın excel 11E15 1,10E+12 11E16 1,10E+13 11E20 1,10E+20 I want to write that goods's code in E

$$Excel-Macros$$ Re: Password

2009-05-11 Thread Mahesh
Hi Harmeet, I m following the given instruction, but unable to open file. after opening ur file , i m opening the other one (Password Protected) which is directly asking for password and i m unable to press AIt+F8. Kindly help. Rgds, Mahender Bisht On Tue, May 12, 2009 at 2:14 AM, Harmeet Sing