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


--
Vnagpal
------------------------------------------------------------------------
Vnagpal's Profile: http://www.excelforum.com/member.php...o&userid=15104
View this thread: http://www.excelforum.com/showthread...hreadid=491960

Keeping my computer busy
 

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
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

Keeping my computer busy
 

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


--
Vnagpal
------------------------------------------------------------------------
Vnagpal's Profile: http://www.excelforum.com/member.php...o&userid=15104
View this thread: http://www.excelforum.com/showthread...hreadid=491960

Keeping my computer busy
 

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

1. WorkSheet protection from ToolsProtection
2. WorkBook protection from ToolsProtection
3. File protection from FileSave AsToolsGeneral 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
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