If you record a macro and save it using the name "Auto_Open", the macro will run whenever you open the workbook that contains the macro.
If you want to save the macro with a particular workbook, open that workbook first.
On the Tools menu, point to Macro, and then click Record New Macro.
In the Macro name box, type Auto_Open.
In the Store macro in box, specify where to save the macro:
To save the macro in the current workbook, choose This Workbook.
To create a new workbook to save the macro in, choose New Workbook.
To save the macro in a hidden workbook that is automatically loaded when you start Excel, choose Personal Macro Workbook.
Note If you choose Personal Macro Workbook, Excel will create and save the macro in a hidden workbook named Personal.xls (if Personal.xls doesn't already exist). In Windows 2000, Personal.xls is saved in the C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLStart folder so that it will be loaded automatically whenever Excel starts. If you want the macro you record and save in Personal.xls to act on a particular workbook, you must also save that workbook in the XLStart folder so that it will also be opened when Excel starts.
Click OK, and then perform the actions you want to record.
On the Stop Recording toolbar, click the Stop Recording button.
If you chose to save the macro in This Workbook or New Workbook in step 4, make sure to save or move the workbook into one of the XLStart folders.
Montagem e Reparação de computadores. Recuperação de dados. Suporte à sua empresa. Solicite já um orçamento! Contacte: errorsolutions.blogspot@gmail.com
Tuesday, February 17, 2009
Monday, February 16, 2009
Add Autoplay in HTML video
Add &autoplay=1 as shown bellow
Example:
<"http://www.youtube.com/v/0F71n8txhKY&hl=en&fs=1&autoplay=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344">
Example:
<"http://www.youtube.com/v/0F71n8txhKY&hl=en&fs=1&autoplay=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344">
Send Ctrl-Alt-Del in Remote Desktop
Wednesday, November 12, 2008
XP não inicia após update do AVG - reboots sucessivos
An update of the popular anti-virus program AVG let a false positive slip through quality control which caused widespread panic on the Internet by desperate AVG users looking for help. The update detected a virus, more precisely Trojan Horse PSW.BANKER4.APSA, in the important system file user32.dll in Windows XP. User32.dll allows programs to implement a graphical user interface and is considered a core component of the Windows XP operating system.
Users who followed the advice of the AVG software program were greeted with a Blue Screen of Death as soon as they clicked on the Heal button to remove the virus. Any attempts to boot the system afterwards failed because of the missing file. AVG was quick to react and released another update that corrected the issue.
This does not help those users who already cleaned the file in Windows.
Here is the official information on how to fix the system for those users:
The system can be restored by following the steps in one of the comments on forum (using safe mode or recovery console and copying c:\windows\system32\dllcache\user32.dll into the right location)
If you need to restore deleted files from AVG Virus Vault you can do it this way:
- Open AVG user interface.- Choose “Virus Vault” option from the “History” menu.- Locate the file that was incorrectly removed and select it (one click).- Click on the “Restore” button.
Users who followed the advice of the AVG software program were greeted with a Blue Screen of Death as soon as they clicked on the Heal button to remove the virus. Any attempts to boot the system afterwards failed because of the missing file. AVG was quick to react and released another update that corrected the issue.
This does not help those users who already cleaned the file in Windows.
Here is the official information on how to fix the system for those users:
The system can be restored by following the steps in one of the comments on forum (using safe mode or recovery console and copying c:\windows\system32\dllcache\user32.dll into the right location)
If you need to restore deleted files from AVG Virus Vault you can do it this way:
- Open AVG user interface.- Choose “Virus Vault” option from the “History” menu.- Locate the file that was incorrectly removed and select it (one click).- Click on the “Restore” button.
Tuesday, August 19, 2008
Set the default Zoom Level in Internet Explorer 7
Question
I upgraded to IE 7. The zoom begins @ 100% each time I start IE. I want it to be 75% but cannot make it default to it. Do you know how to do this?
Answer
By default, Internet Explorer 7 resets the Zoom level to 100% for every new window and new tab opened. To preserve your Zoom Level setting, use these steps:
Open Internet Explorer
From the Tools menu, choose Internet Options
Select the Advanced tab
Under Accessibility, deselect the following option:
Reset Zoom level to 100% for new windows and tabs
Click OK
The user specified Zoom level setting must be preserved from now on.
I upgraded to IE 7. The zoom begins @ 100% each time I start IE. I want it to be 75% but cannot make it default to it. Do you know how to do this?
Answer
By default, Internet Explorer 7 resets the Zoom level to 100% for every new window and new tab opened. To preserve your Zoom Level setting, use these steps:
Open Internet Explorer
From the Tools menu, choose Internet Options
Select the Advanced tab
Under Accessibility, deselect the following option:
Reset Zoom level to 100% for new windows and tabs
Click OK
The user specified Zoom level setting must be preserved from now on.
Subscribe to:
Posts (Atom)