Keeping my computer busy

[Vnagpal]

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

 

[Gord Dibben]

How about

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


Gord Dibben Excel MVP

 

[Vnagpal]

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

 

[Gord Dibben]

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