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.
Press ALT + F11 or click on View Code in Developers Tabs
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:
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.
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!
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:
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’):
If you want to revert this change and go back to the default of an 1024 bit key minimum, run:
Originally posted by Ian Hoogeboom
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!
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:
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/2661254To 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!
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 Ian Hoogeboom
Tuesday, November 25, 2014
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)
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.
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.
- 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.
- Type the number for the appropriate Windows installation, and then type the Administrator account password.
- 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 ) - 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
Subscribe to:
Posts (Atom)