Sunday, December 20, 2015

幸福4FA1 . 快樂小天地: Water Kefir 水克非爾

幸福4FA1 . 快樂小天地: Water Kefir 水克非爾: 2012年尾,在周兆祥博士那處認識水克非爾,試飲過亦覺得好好味。而且又可以自己養,保養得宜便長養長有。上網查資料,原來Kefir源遠流長,已有數百年歷史, 一直在民間流傳。 水克非爾是甚麼? 克非爾是英語kefir的音譯(也有譯為克菲爾、開菲爾),是一種發酵飲料。...

Sunday, September 6, 2015

How to Unprotect an excel sheet without password

This document will tel you how to unprotect an excel spread sheet without having the password
This procedure works in Excel 2010 and earlier but in Excel 2013 this will not work.


In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps.
excel1
Press ALT +  F11 or click on View Code in Developers Tabs
 Excel2
In the Above White Space Enter the below Code. Do not change the code just copy paste:
Sub PasswordBreaker()
    'Breaks worksheet password protection.
    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)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub
Now Click on the Run Button or press F5:
 Excel3

And there you go the sheet is unprotected for you now. Also you would be getting a message in the pop up window.
This Message is contains the password which can be used to unprotect the other sheets in the same workbook.
 Excel4


This document is originally created by Kevin B.

Wednesday, June 3, 2015

Internet Explorer 10 "Continue to this website" option missing

When Internet Explorer 10 (Windows 7 64bit) is use to browse a website with a security certificate problem: “There is a problem with this website’s security certificate.”, the “Continue to this website (not recommended).” option is missing.

The issue here is that Microsoft restricted access to pages which are using a key using less than 1024 bits for protection. Some Oracle product using websites (including Oracle VM Manager) are still using this!
 

Oracle VM Manager using 512bits-key
Oracle VM Manager using 512bits-key

Browsing to the site, (which must be done to https in Oracle VM Manager 3.2), gives the page without the Continue to this website (not recommended) option:

There is a problem with this website's security certificate

There is a problem with this website’s security certificate

Less than 1024 key restriction

After browsing around on the internet I found a Microsoft Knowledge Base article about an advise to block the use of RSA certificates that have keys that are less than 1024 bits long… : http://support.microsoft.com/kb/2661254
To skip all the text on this page to the command one needs to unblock this restriction and for example set the minimum key length to 512; run the following in a elevated command line (cmd.exe ‘run-as-administrator’):
 
certutil -setreg chain\minRSAPubKeyBitLength 512
 
Now the “Continue to this website (not recommended).” is back!

Continue to this website (not recommended).

Continue to this website (not recommended).
If you want to revert this change and go back to the default of an 1024 bit key minimum, run:
 
certutil -delreg chain\MinRsaPubKeyBitLength


Originally posted by

Tuesday, October 28, 2014

Function to truncate or reduce the number of characters in an Excel cell



LEFT(<text>, <num of chars to keep>)
LEFTB for double byte chars like Unicode
=LEFT(<cell address>,<characters to keep starting from left)

Take for example a value in cell A1 that is 10 characters long. We want to reduce it to only display 5 and place it in cell B1. To do so, type the followings in cell B1 and press enter.

=LEFT(A1,5)

Alternatively, first insert a new column beside the original column. In the first cell of the new column that is type in the followings:-

=LEFT(

then click the cell with the value you want to truncate, press the comma button, and type 5, and press enter key.

In the cell B1 that has the new truncated value, notice that in the bottom right of its selection box there is a little square dot. Drag that down to make more truncated version for each of the values in the original column.

Next, with these values still highlighted, copy them. Paste them to a new column and select 'Paste special...'. Select the "Values" radio button and click Ok. This will paste all the values without the Excel Function.

Sunday, January 5, 2014

Windows Server 2003 could not start because the following file is missing or corrupt:

Windows Server 2003 could not start because the following file is missing or corrupt: 

\WINDOWS\SYSTEM32\CONFIG\SYSTEM

After googling the internet, I found the following method to solve the above issue.
  1. Start the computer by using the Windows 2003 CD. At the “Welcome to Setup” screen, press R to repair, and then press C to start the Recovery Console.
  2. Type the number for the appropriate Windows installation, and then type the Administrator account password.
  3. To copy the SYSTEM file from the WINDOWS\Repair folder to the WINDOWS\System32\Config folder, type the following command, and then press ENTER:
    copy c:\windows\repair\SYSTEM c:\windows\system32\config\SYSTEM
    If you receive a prompt to overwrite the file, press Y, and then press ENTER. (You can also copy all the files one by one, as console doesn’t allow you to use * wild card )
  4. Restart the computer.
Windows should be able to boot up normally.

 

Tuesday, October 8, 2013

How to block users from installing or running programs in Windows 7 | 8


You can if you wish to restrict users from installing or running programs in Windows 8, Windows 7 , Windows Vista, Windows XP , Windows 2000 & Windows Server family. You can do so by using certain Group Policy settings to control the behavior of the Windows Installer, prevent certain programs from running or restrict via the Registry Editor.

The Windows Installer, msiexec.exe, previously known as Microsoft Installer, is an engine for the installation, maintenance, and removal of software on modern Microsoft Windows systems.

 


1. Disable or restrict the use of Windows Installer via Group Policy

Type gpedit.msc in start search and hit Enter to open the Group Policy Editor. Navigate to Computer Configurations > Administrative templates > Windows Components > Windows Installer
In RHS pane double-click on Disable windows installer. Configure the option as required.
This setting can prevent users from installing software on their systems or permit users to install only those programs offered by a system administrator. If you enable this setting, you can use the options in the Disable Windows Installer box to establish an installation setting.

The “Never” option indicates Windows Installer is fully enabled. Users can install and upgrade software. This is the default behavior for Windows Installer on Windows 2000 Professional, Windows XP Professional and Windows Vista when the policy is not configured.

The “For non-managed apps only” option permits users to install only those programs that a system administrator assigns (offers on the desktop) or publishes (adds them to Add or Remove Programs). This is the default behavior of Windows Installer on Windows Server 2003 family when the policy is not configured.

The “Always” option indicates that Windows Installer is disabled.

This setting affects Windows Installer only. It does not prevent users from using other methods to install and upgrade programs.

 


2. Always install with elevated privileges

In the Group Policy Editor, navigate to
User Configuration > Administrative Templates > Windows Components
Scroll down and click Windows Installer and configure it to Always install with elevated privileges.

This setting directs Windows Installer to use system permissions when it installs any program on the system.

This setting extends elevated privileges to all programs. These privileges are usually reserved for programs that have been assigned to the user (offered on the desktop), assigned to the computer (installed automatically), or made available in Add or Remove Programs in Control Panel. This setting lets users install programs that require access to directories that the user might not have permission to view or change, including directories on highly restricted computers.

If you disable this setting or do not configure it, the system applies the current user’s permissions when it installs programs that a system administrator does not distribute or offer.

This setting appears both in the Computer Configuration and User Configuration folders. To make this setting effective, you must enable the setting in both folders.

Skilled users can take advantage of the permissions this setting grants to change their privileges and gain permanent access to restricted files and folders. Note that the User Configuration version of this setting is not guaranteed to be secure.

 


3. Don’t run specified Windows applications

In the Group Policy Editor, navigate to
User Configuration > Administrative Templates > System
Here in RHS pane, double click Don’t run specified Windows applications and in the new window which opens select Enabled. Now Under Options click Show. In the new windows which opens enter the path of the application you wish to disallow; in this case : msiexec.exe.
This will disallow Windows Installer which is located in c:\Windows\System32\ folder from running.
This setting prevents Windows from running the programs you specify in this setting. If you enable this setting, users cannot run programs that you add to the list of disallowed applications.

This setting only prevents users from running programs that are started by the Windows Explorer process. It does not prevent users from running programs, such as Task Manager, that are started by the system process or by other processes. Also, if you permit users to gain access to the command prompt, cmd.exe, this setting does not prevent them from starting programs in the command window that they are not permitted to start by using Windows Explorer. Note: To create a list of disallowed applications, click Show. In the Show Contents dialog box, in the Value column, type the application executable name (e.g., msiexec.exe).

 

 

4. Restrict Programs from being installed via Registry Editor

Open Registry Editor and navigate to the following key:
HKEY_CURRENT_USER\Software\Microsoft\Windows\Current Version\Policies\Explorer\DisallowRun
Create String value with any name, like 1 and set its value to the program’s EXE file.
e.g., If you want to restrict msiexec, then create a String value 1 and set its value to msiexec.exe. If you want to restrict more programs, then simply create more String values with names 2, 3 and so on and set their values to the program’s exe.
You may have to restart your computer.

- The SWC’s workstation for Parit Raja 4, Yong Peng 3 and Simpang Renggam 2 has been disabled its windows installer. LogMeIn connection to Simpang Renggam 2 WTP is very slow but it was still possible to make the following settings. 
  a. Disable windows installer - Enabled > Always
  b. Don’t run specified Windows applications - c:\windows\system32\msiexec.exe