Keeping my computer busy

Hello Frnds,

I need ur help here...

Do we have a loop function with which I can keep my excel busy and my computer busy....when I am not at my desk...a small simple loop function in excel

Thanks in advance
Vikram

How about

Sub loopit()
Do Until Range("A1").Value = 2
Range("A1").Value = 1
Loop
End Sub


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 14:10:06 -0600, Vnagpal
<Vnagpal.1zqmem_1134072606.4935@excelforum-nospam.com> wrote:

>
>Hello Frnds,
>
>I need ur help here...
>
>Do we have a loop function with which I can keep my excel busy and my
>computer busy....when I am not at my desk...a small simple loop
>function in excel
>
>Thanks in advance
>Vikram

Thank u sir.....U r great...but one more thing...do we have a way by which we can break a password protected excel worksheet.....it doesnt open..it asks for password whenever i try to open it....thanks again

Note: there are 3 types of Protection which can all be passworded.

1. WorkSheet protection from Tools>Protection
2. WorkBook protection from Tools>Protection
3. File protection from File>Save As>Tools>General Options(XL2002)

And a fourth one if you count Protection on a VBA Project

Which are you referring to?

If worksheet or workbook only, these are easy to crack.

File and VBA not so simple.

See John McGimpsey's site for instructions.

http://www.mcgimpsey.com/excel/removepwords.html


Gord Dibben Excel MVP

On Fri, 9 Dec 2005 17:06:27 -0600, Vnagpal
<Vnagpal.1zspen_1134169801.3795@excelforum-nospam.com> wrote:

>
>Thank u sir.....U r great...but one more thing...do we have a way by
>which we can break a password protected excel worksheet.....it doesnt
>open..it asks for password whenever i try to open it....thanks again