Excel Macro para quitar Password

Abres el editor de VB
ALT + F11
Creas un Modulo
Insretar>Modulo
Y pegas el codigo de abajo
-------------------------------------

Sub PasswordBreaker()
'Author unknown but submitted by brettdj of www.experts-exchange.com

Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126


ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next

End Sub
-------------------------
Close the VB Editor window. Navigate to the worksheet you want to unprotect. Hit Tools-Macro-Macros and double-click PasswordBreaker in the list

fuente

Decrease your Applications startup time

By default, Microsoft includes the /prefetch:1 switch to speed up it's Windows Media Player application start time. This switch can be used for other Windows applications and also many third party programs.

Example #1

You have AOL 8.0 installed on the computer. Complete the steps outlined bewlo to add the /prefetch:1 switch to AOL's Target path.

1. Right click on the AOL shortcut and select properties from the menu.

2. In the Target: Field add the /prefetch:1 switch to the very end of the path, like this: "C:\Program Files\America Online 8.0\aol.exe" /prefetch:1 and then click ok.

Now start AOL. It would load at least 50 times faster than ever before.

Example #2

1, Go to the Start button/All Programs/Accessories/System Tools

2. Right click on System Restore and select properties from the menu that appears. Add the /prefetch:1 to the Target Path entry so it looks like this %ystemRoot%\System32\restore\rstrui.exe /prefetch:1 and click ok.

Now System Restore will start immediately when executed.

Note: This switch will only work with some programs. Others will return a message saying the program in the target box is invalid. Just remove the switch (by Allan, forum admin).

FUENTE

Elimine el arranque doble

Estoy usando un sistema que tiene instalados Windows XP y Windows 98. Ya no quiero usar Windows 98, pero no sé qué debo hacer para eliminar el esquema de arranque doble.

Para eliminar ese menú que dice “Por favor seleccione el sistema operativo …” cada vez que enciende su sistema, cargue Windows XP, pulse el botón Inicio, pulse Mi PC con el botón derecho y seleccione Propiedades•Avanzado. Escoja el botón Configuración debajo de ‘Inicio y recuperación’.

Si la instalación de XP no aparece como el ‘Sistema operativo predeterminado’, selecciónelo del menú desplegable, pulse Aceptar dos veces y reinicie el sistema. Regrese a ‘Inicio y recuperación’ y pulse el botón Editar para abrir el archivo boot.ini en el Bloc de notas. Borre la última línea del archivo, que debe ser la opción de arranque que ya no quiere. Guarde el archivo, salga del Bloc de notas, pulse Aceptar dos veces y reinicie el sistema. Ahora XP debe cargarse sin que aparezca el menú.

Si tropieza con algún problema, use el servicio Restauración del sistema para regresar a donde estaba y volver a intentar el cambio.

Si tiene algún programa de particiones, como Symantec PartitionMagic, puede borrar la partición de Windows 98 y ampliar la que contiene a Windows XP. Pero si no, no se preocupe y utilice la partición de Win 98 para almacenar copias de seguridad o para cualquier otro propósito.

FUENTE

How Do I Prevent Applications From Stealing Focus

By default Windows XP automatically prevents an application from stealing focus. You have probably already noticed this when you have had a number of applications minimised to the taskbar and one particular application has wanted you attention so the tab of the minimised application starts flashing orange. However, there have been cases where the minimised application tab refuses to flash orange when the application has attempted to grab focus. This is because an application you have installed has disabled the prevent an application from stealing focus option. To remedy the problem proceed as follows.

The first, and perhaps the easiest, root is to attempt a System Restore back to a point when you had full functionality of the flashing taskbar tab. In most cases this will remedy the problem.

If this option fails then the next easiest option is to download the Microsoft Powertoy TweakUI, available from (http://www.microsoft.com/windowsxp/downloads/powertoys/xppowertoys.mspx) Click the + sign next to the General option and then click on Focus. Now make sure a tick is in the box marked Prevent applications from stealing focus.

If that option fails you can always try editing the Windows registry.

NOTE

For safety reasons it is always advisable to backup the registry before you start editing it. While there are numerous third party application that will do this for you, i.e., ERUNT, you can just as easily backup the registry using Windows XP.

1/ Click the Start button

2/ From the Start Menu click Run

3/ In the Run dialogue box type regedit

4/ When the registry window opens navigate to the following Registry key:

HKEY_CURRENT_USER/ControlPanel/Desktop

5/ Click on the Desktop option and then look down the list on the right
for the following:

foregroundlocktimeout

6/ The right hand list is divided into three sections - Name Type and
data.

7/ Look in the Data section and check that the following is present:

0x00030d40 (200000)

8/ If this data is present then the Prevent applications from stealing focus option is enabled.

9/ If you have something different then proceed as follows:

10/ Right click on the ForegroundLockTimeout option and select Modify

11/ The Edit DWORD value box opens

12/ Make sure there is a green dot next to the hexadecimal option in the Base box

13/ Now in the Value data box type: 30d40 (that's thirty followed by d
then followed by 40)

14/ Click the OK button

15/ Your entry should now read:

ForegroundLockTimeout REG_DWORD 0x00030d40 (200000)

16/ Now close regedit and reboot your machine