Freeze multiple column in excel

On occasion where i want to freeze multiple column in excel, i just need to highlight the cell next to it as below:

For above example D1,

click view> Freeze panes.

Now all column from D on wards are freeze.

Password Protect WordPress Attachments (files)

I had a website where users can upload important file to share. i used one of the option provided by web host in the cp called, 'Secured folder'. so other people on the net cannot access the file.

Well, recently the option no longer supported, and i had to look around on the net to find a simpler solution other than subscribing to an 'additional services'. 

so i found one, which is this.

You might have some sections of your WordPress site that are only accessible for your WordPress user. Pretty easy to protect the page or post in WordPress for only the registered user but what about the attachments of the post/page (files, images)?

They won’t be protected by default, this means if a request is made directly to the file it can be accessed without any password. There is potentially the solution where you protect the files in a directory with htaccess password, but do you really want to manage new set of username and password outside or WordPress? Not really.

Here is the solution, use htaccess to check if a user is logged in the WordPress site when accessing the files area, if not then redirect to the WordPress login page. Here is the new .htaccess:

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_URI} ^.*uploads/.*
RewriteCond %{HTTP_COOKIE} !^.*wordpress_logged_in.*$ [NC]
RewriteRule . /wp-login.php?redirect_to=%{REQUEST_URI} [R,L]
RewriteRule ^index\.php$ – [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

We simply have protected the whole uploads area and redirect to login if the user is not logged. You can protect a different directory.

basically just create a file called .htaccess (note that.htaccess is the extension, if you create .htaccess.php for examples, it wont work) with the code above and place it inside the folder that you want to protect.

Cheers.

No more connections can be made to this remote computer

Recently i come to a problem where too many people try to access a shared folder on windows XP.

i have come to this solution on the net, hope it works.

When using Windows XP Professional as a server for more than 10 client pc, maybe you will encounter this kind of error;

No more connections can be made to this remote computer at this time because there are already as many connections as the computer can accept.

This error is caused by the limitation of Windows XP Professional to 10 connection only. To solve this problem, you have to edit your registry. Follow this steps;

1. Click START -> RUN
2. Type regedit
3. Go to \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon
4. Look for cachedlogonscount
5. Replace its value to your desired number of connection, for example 15.

That’s it!