How to Enable Macro in Microsoft Office Excel 2007?

• Open Microsoft Office Excel 2007 Click on Office logo at the very Left hand Top
• Then select "Excel Options", select "Trust Centre" on left hand side and click on "Trust Centre Settings"
• Select "Macro Settings" and then select "Enable all Macros", if Macros are also written in Visual Basics programming, put check before "Trust access to the VBA project object model"

How to find Serial number of machine?

To find out the serial number of the machine, go to windows command prompt and type following command on the command prompt,

1. Start > cmd
2. C:\Users\XYZ > wmic csproduct get identifyingnumber,vendor,name

It will give you the output like
IdentifyingNumber    Name          Vendor
L3ZZ896                  5897X7Y     LENOVO

Where IdentifyingNumber is Serial number of machine, Name is Productid and Vendor is the name of manufacturer

How to Fix Corrupted Vista Profile?

Follow the following steps in order to recreate a user’s Vista profile when it gets corrupted.

1. log into user’s workstation with your admin account
2. Delete user’s local profile on C: drive under users folder
3. Click on Start and run and type “Regedit”
4. This will open Registry Editor Window
5. Click on + sign besides HKEY_LOCAL_MACHINE
6. Click on + sign besides SOFTWARE
7. Click on + sign besides MICROSOFT
8. Click on + sign besides WINDOWS NT
9. Click on + sign besides CURRENT VERSION
10. Click on + sign besides PROFILELIST and delete the SID number points to user name in Right side Pane
11. Close Registry Editor window.
12. Now RDP into the Server hosting that user’s profile.
13. Go to Profiles folder and locate the user’s windows vista profile
14. Rename this profile folder
15. Ask the user to login and then logoff
16. Now copy the user’s favorites and Desktop icons from the renamed profile folder to the new profile folder
17. Ask user to login again and this will create a new profile for the user successfully.

How to fix network printer dirver error for HP printers

1. Delete the printer having printing problem from the printer window.
2. Click on Start and Run and type in Regedit.
3. This will open Registry editor window.
4. Click on + sign besides HKEY_LOCAL_MACHINE
5. Click on + sign besides SYSTEM
6. Click on + sign besides CurrentControlSet
7. Click on + sign besides Control
8. Click on + sign besides Print
9. Click on + sign besides Environments
10. Click on + sign besides Windows NT x86
11. Click on + sign besides Drivers
12. Click on + sign besides Version-3
13. Right click on the printer name and delete it
14. Click on + sign besides Monitors and delete the folder for that printer
15. Close the Registry Editor
16. Go to System32 folder under C:\Windows\System32
17. Click to open spool folder and click to open drivers folder
18. Click to open w32x86 folder and click on 3 folder
19. Under 3 folder delete all the instances for the printer giving problems
20. Reboot computer and install the printer again
21. It should work fine now.