Disable Copy & Paste / Cut command in Office 2003

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

Option Explicit Sub 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.


~

Decode original long URL from short URL easily

Decode original long URL from short URL easily

Those of you who use social networking services like twitter, facebook etc. know very well that apart from normal use, these social networking is used extensively by spammers for spamming using shortened URLs. These short URLs are created using URL shortening services like bit.ly, cli.gs, digg.com, fb.me, is.gd, j.mp, kl.am, su.pr, tinyurl.com, goo.gl and many more.

These short URLs are often bad as they give you no idea where the actual link goes to and may secretly link to yucky websites, phishing URLs, Malware websites etc. Due to misue of these short URLs, you should be aware of the actual URLS behind the short URL. Even though these short URL services like tinyURL does provide a way to decode the actual URL from short one, but considering the sheer volume of short links going around on web, its almost impossible to go to TinyURl or some other website to decode these links manually everytime.

Hence you need a automated way to decode these links. Long URL Please is a small Firefox Addon which when installed automatically decodes the short URLs on webpages. You need not do anything from your side. Everything is done automatically by replacing any of these links when every web page loads.



This addon supports 80 URL shortening services like bit.ly, cli.gs, digg.com, fb.me, is.gd, j.mp, kl.am, su.pr, tinyurl.com, goo.gl and many more.

Download the add-on here Long URL Please


~

Mysterious Graphical Handling

Mysterious Graphical Handling

Microsoft Word has a handy feature for manipulating shapes and graphics in documents. When you've placed multiple graphical elements, you can group them so they stay together when you move them and remain the same relative size when you resize them.
But in Word 2007 this feature seems not to work. You can't select multiple graphical items, so there's no way to group them or determine which overlapping objects are in front of which others. !

It turns out that in Word 2007, there's an extra step. Before you start adding graphics you have to define a "Canvas" to hold them.
Click Insert -> Shapes -> New Drawing Canvas.
Add your pictures and shapes to the drawing canvas. Now you can group them, ungroup them, put one behind another, and so on—all the actions that you were accustomed to in Word 2003.


~

Recover Vista's screenshot-snipping tool

Recover Vista's screenshot-snipping tool

The Vista's screenshot-snipping tool Premium, in Accessories very useful.
After the latest update from Microsoft, It might get disappeared.

Vista's screenshot-snipping tool may simply be turned off, or it may be turned on and Windows is ignoring it. Launch Programs and Features from Vista's Control Panel. Click the link Turn Windows features on or off at left. Find the Tablet PC Optional Components box. If it's not checked, check it and click OK. If it is checked, click to uncheck it, click OK, then click to check it again and click OK.
& Reboot.


~

Completely Clear the Web History of IE

Completely Clear the Web History of IE

You have cleared your IE history but some previously visited sites still show up in the address-bar of your browser.

Even if you try almost every possible method and that includes resetting the IE browser to factory defaults, removing the registry entries, running CCleaner to delete the stubborn index.dat, clearing the Temp folders manually, disabling add-ons (IE in Safe Mode) but, unfortunately, none of them works.

Click here for the detailed steps, to Completely Clear the Web History of IE.


~

Most Contacted Email Addresses in Gmail

Most Contacted Email Addresses in Gmail

Here’s how you can find the list of most contacted email addresses from your Gmail account:


Step 1. Open your Gmail Inbox and click the Contacts link in the sidebar.

Step 2. Click the Export button and choose the “Most Contacted” option in the drop-down to export all those email address in a single CSV file.

Step 3. Save this file to a safe location as you might need it if your Gmail Account is hacked.


~

Backup Gmail Inbox Online

Backup your Gmail Inbox Online

If you want to backup your emails from Gmail to the local computer, enable POP3 access in your Gmail settings and then use a desktop mail client to download a copy of all your messages from the Google cloud to the local disk.


Why you should backup Gmail to the cloud?

If you are not a huge fan of desktop applications or if you think that setting up a Gmail backup plan involves way too much effort, you can consider creating a backup of your Gmail account in the cloud itself. Before we get into the details, here are three situations where an online backup of Gmail messages will come handy:

Reason #1 – If your main Gmail account gets hacked, you will still have access to all your previous emails.

Reason #2 – If you delete an important email from your Gmail Inbox by mistake, you can easily retrieve it from the online backup. Google Apps Premier has Postini to restore deleted emails, here you’re getting that facility for free.

Reason #3 – If the Gmail service goes down, you will still be able to read your older emails. Gmail outage won’t affect work.


Backup your Gmail Messages Online

There are three services that can help you automatically backup your Gmail (and Google Apps) email accounts online.



The first and most obvious choice is Gmail. Create a new Gmail account and under Settings –> Accounts and Import –> Check mail using POP3 –> Add POP3 email account, enter the email address of your main Gmail account that you want to backup.

Within an hour or so, the online mail fetcher program will pull messages from your main Gmail account and will copy them to your new “backup” account. In my limited testing, I found that Gmail’s mail fetcher left all the messages that were either “read” or have been previously downloaded by another POP3 client so it’s not “true backup.”

That brings us to another alternative – copy your Gmail mailbox to Windows Live Hotmail. While you can add a Gmail account to Hotmail using POP3 (just like Gmail’s mail fetcher), there’s a much better and reliable option out there for copying emails from Gmail into Hotmail and it’s called TrueSwitch.



Setup a new Hotmail account and TrueSwitch, an awesome web-based email account migration service, will copy all your emails and attachments from Gmail to your new Hotmail address. If you have a relatively large Gmail Inbox, the backup process might take up to 24 hours but you’ll get an email as soon as the transfer is complete.

Like Gmail, Hotmail too offers “expanding” storage so it can possibly fit your large Google inbox as well. You can then add your Gmail address to Hotmail (click “Add an email account” in the sidebar) and this will ensure that new messages that land in your Gmail inbox in the future are also saved in Hotmail.

That said, both the services discussed above have one common drawback – they’ll always backup your entire Gmail mailbox and you cannot limit the backup process to a specific set of folders (or labels in Gmail). So if you have a fairly large mailbox and don’t want to backup each and every Gmail folder (or label), try Backupify.



Backupify, can backup your online accounts (including Gmail) to Amazon S3 and a unique point about Backupify is that it lets you specify labels that should be included in the backup process. The messages are stored in the cloud as EML files that you can view inside Outlook or, you can change the .eml extension to .mht, and read the file inside IE.

Backupify supports XOauth so you can add your Gmail account to the service without having to share your Google Account credentials. The advantage is that Backupify will scan your selected mailbox folders every single day for new emails and will archive them automatically.


Note: Try TrueSwitch,Backupify & other 3rd party tools at your own risk.
CosmoCyber is not responsible, if your Gmail account is compromised.


~