Archive

Archive for April, 2010

Disable Copy & Paste / Cut command in Office 2003

April 28, 2010 Leave a comment

To disable Copy & Paste command in Office 2003, Install this code into the workbook:

Option ExplicitSub EnableControl(Id As Integer, Enabled As Boolean)
Dim CB As CommandBar
Dim C As CommandBarControl
For Each CB In Application.CommandBars
Set C = CB.FindControl(Id:=Id, recursive:=True)
If Not C Is Nothing Then C.Enabled = Enabled
Next
End Sub

Private Sub Workbook_Activate()
EnableControl 21, False ‘ cut
EnableControl 19, False ‘ copy
EnableControl 22, False ‘ paste
EnableControl 755, False ‘ pastespecial
Application.OnKey “^c”, “”
Application.OnKey “^v”, “”
Application.OnKey “+{DEL}”, “”
Application.OnKey “+{INSERT}”, “”
Application.CellDragAndDrop = False
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
EnableControl 21, True ‘ cut
EnableControl 19, True ‘ copy
EnableControl 22, True ‘ paste
EnableControl 755, True ‘ pastespecial
Application.OnKey “^c”
Application.OnKey “^v”
Application.OnKey “+{DEL}”
Application.OnKey “+{INSERT}”
Application.CellDragAndDrop = True
End Sub

Private Sub Workbook_Deactivate()
EnableControl 21, True ‘ cut
EnableControl 19, True ‘ copy
EnableControl 22, True ‘ paste
EnableControl 755, True ‘ pastespecial
Application.OnKey “^c”
Application.OnKey “^v”
Application.OnKey “+{DEL}”
Application.OnKey “+{INSERT}”
Application.CellDragAndDrop = True
End Sub

Private Sub Workbook_Open()
EnableControl 21, False ‘ cut
EnableControl 19, False ‘ copy
EnableControl 22, False ‘ paste
EnableControl 755, False ‘ pastespecial
Application.OnKey “^c”, “”
Application.OnKey “^v”, “”
Application.OnKey “+{DEL}”, “”
Application.OnKey “+{INSERT}”, “”
Application.CellDragAndDrop = False
End Sub

• Open up your workbook.
• Get into VBA (Press Alt+F11)
• Double click on (This WorkBook) in the left-hand pane
• Copy and Paste in the code (given below)
• Save your sheet.

So, now when the sheet is opened, the copy and paste functions will be disabled.

Note:
1:When you close the sheet, they will be re-enabled.
2:f the user selects “disable macros” when opening the sheet, they won’t work…the sheet will open with cut/copy/paste still working.

~

Categories: MS Office

Websites and Words That Are Blocked in China

April 27, 2010 Leave a comment

Websites and Words That Are Blocked in China

There are generally two kinds of internet censorship in China – they either completely block a website from users or they instruct local search engines to modify search results for certain keywords.

For instance, sites like IMDB and BBC are inaccessible from within China and some of them may not even appear in the search results of local search engines like Baidu or Sohu. The next form of censorship is keyword based. If you search for a censored keyword (say “Human Rights”) in a Chinese search engine, you’ll see few or no results.

~

Categories: Internet, Web

"Registry editing has been disabled by your administrator" Error

April 27, 2010 Leave a comment

Error “Registry editing has been disabled by your administrator” when you open the Registry Editor in Windows Vista

When you attempt to start the Registry Editor (regedit.exe) in your Windows Vista system, you may receive the following message:

Registry editing has been disabled by your administrator

If the above error message is shown in a standalone system, then it may be a result of Malware infection. It is also possible that the DisableRegistryTools policy had been enabled by a third-party tweak program which you may be using. It’s highly advisable to follow up with a complete system checkup for Virus and Malware, especially when you’re unsure about the cause.

Note: If your system is connected to a domain, your network administrator may have enabled the DisableRegistryTools Policy setting. In that case, you’ll need to contact the network administrator to relax this restriction, if need be.

Method 1 – Using Group Policy Editor
If you are using an edition of Windows Vista (Windows Vista Business, Enterprise and Ultimate editions) which includes the Group Policy Editor, follow these steps:

Click Start, type gpedit.msc in the Search box, and press ENTER
Go to the following branch:
User Configuration | Administrative Templates | System

Double-click Prevent access to registry editing tools
Set it as Not Configured

Important: If it’s already set to Not Configured, set it to Enabled and click Apply. Then repeat the steps and revert the setting back to Not Configured. This removes the registry based policy if set already.

Method 2
This method should work in all editions of Windows Vista.

Copy the below code & paste in Notepad. Save the file on Desktop & name it reg_enable.vbs.

‘Copyright © 2010 Cyber KGB. All rights reserved.
”Description: Resets the “Prevent access to registry editing tools”
‘ Policy in Windows Vista. If UAC is enabled, this script needs to
‘ be run from an elevated Command Prompt.
‘Compatibility: This script was tested under Windows Vista only.

Option Explicit
Dim WshShell, strUserName, strDomain, strSID
Dim objWMIService, colItems, objItem, arrName, objAccount

Set WshShell = WScript.CreateObject(“WScript.Shell”)
Set objWMIService = GetObject(“winmgmts:\\.\root\cimv2”)
Set colItems = objWMIService.ExecQuery(“Select * From Win32_ComputerSystem”)

For Each objItem in colItems
arrName = Split(objItem.UserName, “\”)
strDomain = arrName(0)
strUserName = arrName(1)
Next

Set objAccount = objWMIService.Get _
(“Win32_UserAccount.Name='” & strUserName & “‘,Domain='” & strDomain & “‘”)
strSID=objAccount.SID

If trim(strSID) “” then
WshShell.RegDelete (“HKEY_USERS\” & strSID & “\Software\Microsoft\Windows\CurrentVersion\Policies\System\DisableRegistryTools”)
Msgbox “Completed!”
End if

Open an elevated command prompt. To do this, click Start, click
All Programs
, click Accessories, right-click Command Prompt, and then click Run as administrator. If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.
Switch to your Desktop directory by typing the following command, and then pressing ENTER:

cd /d %userprofile%\desktop

Then, type the following command and press ENTER

wscript.exe reg_enable.vbs

Type EXIT to close the Command Prompt window.
If everything worked fine, the DisableRegistryTools policy should have been removed by now. See if you’re able to launch Regedit.exe now

Note: If your system is connected to a domain, your network administrator may have enabled the DisableRegistryTools Policy setting. In that case, you’ll need to contact the network administrator to relax this restriction, if need be.

~

Categories: Errors, Vista

"This language is no longer available for spell checking" Error

April 27, 2010 Leave a comment

Error “This language is no longer available for spell checking” when using the Spell Checker in Windows Mail

When you use the Spell check feature when composing a new mail message in Windows Mail, the following error message may be displayed:

This happens if the default language is not set in the spell checker options. Follow these steps to resolve the problem:

1. Start Windows Mail

2. From the main screen in Windows Mail, click the Tools menu and choose Options.

Note: In step 2, make sure that you select the Tools menu from the main window, not the New Mail message window.

3. Click the Spelling tab From the Language drop-down, select English even though it’s already listed as the default selection, and click Apply.

4. Click OK

~

Categories: Errors, Vista

"Access is denied" – Log off Error

April 27, 2010 Leave a comment

Error “Access is denied” when you try to log off an user account using Task Manager Users tab in Windows Vista

When you use the Task Manager Users tab to log off an user account in Windows Vista, the following error may appear:

User {username} (SessionId=2) could not be logged off. Access is denied.

This happens if Task Manager is not running under administrative privileges. To log off an user account, Task Manager must be run with administrative privileges. Follow one of these methods:

Method 1
Open Task Manager (taskmgr.exe) and click the Processes tab
Click Show processes from all users
When you are prompted for an administrator password or confirmation, type the password or provide confirmation.
Task Manager now runs with administrative privileges.
Switch to the Users tab and log off an user account.

Method 2
Click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.
If you are prompted for an administrator password or for confirmation, type your password, or click Continue.
At the command prompt, type taskmgr.exe, and then press ENTER.
Task Manager starts with administrative privileges.
Switch to the Users tab and log off an user account.

~

Categories: Errors, Vista

Shut Down Quickly via Sleep Button

April 27, 2010 1 comment

Shut Down Windows Vista Quickly via Sleep Button

It takes a couple of confusing steps to “Shut down” Windows Vista. You click that Start button, go past the “Power Off” button (since it’s meant for putting your computer in Sleep mode) and then select “Shut Down” from six other options.

Luckily, there’s an easy way to change this default setting and you can use the Power Off button in the Vista start menu to Shut Down and not switch to Sleep mode.

Go to Control Panel –> Power Options –> Change Plan Settings –> Change advanced power settings –> Power Buttons and Lid –> Start menu power button and change the setting from Sleep to Shut Down.

~

Categories: Vista

Error 0x80070032 when creating a System Restore point in Windows Vista

April 27, 2010 1 comment

Error 0x80070032 when creating a System Restore point in Windows Vista

When you try to create a System Restore point in Windows Vista, the following error may occur:

This happens if the Windows Event Log and the Task Scheduler services are disabled. Follow these steps to fix the problem.

1. Click Start, Services.msc. Press {ENTER}

2. Double-click Windows Event Log

3. In the Start type list box, ensure that Automatic is selected

4. Click Start to start the service, if it’s not already running

5. Close the Services console

6. Reboot.

It should work fine

If the problem still persists, check the status of the Windows Event Log and Task Scheduler services. If the Task Scheduler service is in a disabled state, then paste code below in a notepad & save the file as schedule.reg.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Schedule]
“AtTaskMaxHours”=dword:00000048
“DisplayName”=”@%SystemRoot%\\system32\\schedsvc.dll,-100”
“Group”=”SchedulerGroup”
“ImagePath”=hex(2):25,00,73,00,79,00,73,00,74,00,65,00,6d,00,72,00,6f,00,6f,00,\
74,00,25,00,5c,00,73,00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,73,\
00,76,00,63,00,68,00,6f,00,73,00,74,00,2e,00,65,00,78,00,65,00,20,00,2d,00,\
6b,00,20,00,6e,00,65,00,74,00,73,00,76,00,63,00,73,00,00,00
“Description”=”@%SystemRoot%\\system32\\schedsvc.dll,-101”
“ObjectName”=”LocalSystem”
“ErrorControl”=dword:00000001
“Start”=dword:00000002
“Type”=dword:00000020
“DependOnService”=hex(7):52,00,50,00,43,00,53,00,53,00,00,00,45,00,76,00,65,00,\
6e,00,74,00,4c,00,6f,00,67,00,00,00,00,00
“ServiceSidType”=dword:00000001
“RequiredPrivileges”=hex(7):53,00,65,00,49,00,6e,00,63,00,72,00,65,00,61,00,73,\
00,65,00,51,00,75,00,6f,00,74,00,61,00,50,00,72,00,69,00,76,00,69,00,6c,00,\
65,00,67,00,65,00,00,00,53,00,65,00,43,00,68,00,61,00,6e,00,67,00,65,00,4e,\
00,6f,00,74,00,69,00,66,00,79,00,50,00,72,00,69,00,76,00,69,00,6c,00,65,00,\
67,00,65,00,00,00,53,00,65,00,41,00,75,00,64,00,69,00,74,00,50,00,72,00,69,\
00,76,00,69,00,6c,00,65,00,67,00,65,00,00,00,53,00,65,00,49,00,6d,00,70,00,\
65,00,72,00,73,00,6f,00,6e,00,61,00,74,00,65,00,50,00,72,00,69,00,76,00,69,\
00,6c,00,65,00,67,00,65,00,00,00,53,00,65,00,41,00,73,00,73,00,69,00,67,00,\
6e,00,50,00,72,00,69,00,6d,00,61,00,72,00,79,00,54,00,6f,00,6b,00,65,00,6e,\
00,50,00,72,00,69,00,76,00,69,00,6c,00,65,00,67,00,65,00,00,00,53,00,65,00,\
54,00,63,00,62,00,50,00,72,00,69,00,76,00,69,00,6c,00,65,00,67,00,65,00,00,\
00,53,00,65,00,52,00,65,00,73,00,74,00,6f,00,72,00,65,00,50,00,72,00,69,00,\
76,00,69,00,6c,00,65,00,67,00,65,00,00,00,00,00
“FailureActions”=hex:80,51,01,00,00,00,00,00,00,00,00,00,03,00,00,00,14,00,00,\
00,01,00,00,00,60,ea,00,00,01,00,00,00,60,ea,00,00,00,00,00,00,00,00,00,00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Schedule\Parameters]
“ServiceDll”=hex(2):25,00,73,00,79,00,73,00,74,00,65,00,6d,00,72,00,6f,00,6f,\
00,74,00,25,00,5c,00,73,00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,\
73,00,63,00,68,00,65,00,64,00,73,00,76,00,63,00,2e,00,64,00,6c,00,6c,00,00,\
00
“ServiceDllUnloadOnStop”=dword:00000001
“ServiceMain”=”ServiceMain”

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Schedule\Enum]
“0”=”Root\\LEGACY_SCHEDULE00″
“Count”=dword:00000001
“NextInstance”=dword:00000001

;CyberKGB

Save the file to the Desktop, and double-click the file to merge the contents with the registry. Click Yes when asked for confirmation.

Restart Windows.

Categories: Errors, Vista

YouTube Video Turned into a Virtual Piano

April 27, 2010 Leave a comment

YouTube Video Turned into a Virtual Piano

Hit the play button, wait until the video loads in your browser and then click any of the piano keys inside the YouTube video itself to play some music.

~

Categories: Web

Expand the YouTube Video Player to its Maximum Size within the Browser

April 27, 2010 Leave a comment

Expand the YouTube Video Player to its Maximum Size within the Browser (Not Full Screen)

The default full screen button in the YouTube video player expands the video such that it covers your entire desktop area and all existing windows on the screen stay hidden as long as you are watching the video is this “maximized” state.

But what if you want more control over the size of the YouTube video player, here’s a simple hack – just replace the word “watch” in the URL of any YouTube video with “watch_popup” and the video will expand to fit your browser window, not the desktop.

For instance, if the original YouTube video is located at ..

youtube.com/watch?v=2mrRvUNlq50

the same video can be accessed standalone outside the YouTube website at..

youtube.com/watch_popup?v=2mrRvUNlq50

Resizing the browser window will also resize the YouTube player and you can press F11 in Firefox to mimic YouTube’s full screen mode even with this hack.

~

Categories: Web

Login into Facebook With Your Google or Yahoo Account automatically

April 27, 2010 Leave a comment

Login into Facebook With Your Google or Yahoo Account automatically

You can now link both your Google Account (including Gmail) and Yahoo ID with your Facebook profile.

The advantage of linking you other online accounts with Facebook is that if you are signed-in into any of the above services, you’ll automatically be logged into Facebook as well. So for example, if you working in Google Docs or writing scraps in Orkut and then decide to open Facebook in another tab, you won’t see the Facebook sign-in screen anymore.

To set up this association between Facebook and Yahoo/Google Accounts, just go to Facebook -> Accounts Settings and click “Add a new linked account“.

Facebook lets you link only one account per web service so choose the ID that you use most frequently on the web.


Click ALLOW , when you see the above message.

~

Categories: Web