Archive
>Indian Rupee Symbol using Windows Fonts
>The India Rupee symbol is now part of the official Unicode standard but for you to type that new currency sign into your favorite word processor or spreadsheet using a regular keyboard, your existing fonts must be updated to the new standard as well.
Microsoft has recently updated all the common fonts the ship with Windows to include support for the new Indian Rupee symbol. Now you can open a document inside Microsoft Word (or notepad), select a popular font family like Arial or Times New Roman, and type the Rupee sign directly.
Update your existing Windows fonts by installing the kb2496898 hotfix available for both Windows Vista and Windows 7. Once installed, this will update the Arial.ttf, Times.ttf, Tahoma.ttf and some of the other font files on your computer with the latest version.
How to Type the Indian Rupee Symbol using Arial
Launch Microsoft Word, change the document font to Arial or Tahoma, and type 20B9 followed by Alt-x. If the 20b9 string is converted into a Rupee symbol, as in the screenshot above, the update has been successfully applied.
~
Office 2010 PowerPoint Viewer
PowerPoint Viewer for People Who Don’t Have Office 2010
PowerPoint Viewer, as you probably know, is a free application that lets you view PowerPoint presentations on your computer even if you don’t have Microsoft Office installed on your computer.
Microsoft Office 2010 team released a new version of their PowerPoint Viewer that’s much like its predecessor except that it also supports the new PowerPoint 2010 file format.
The PowerPoint viewer can play the new transitions and video effects that were introduced in Office 2010 but if you embedded a web video in your presentations, that won’t play through the standalone viewer.
Also, the PowerPoint Viewer requires installation – had it been a portable utility, you could just copy the presentation and the viewer on a USB drive and deliver presentations on any Windows computer.
~
Disable Copy & Paste / Cut command in Office 2003
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() Private Sub Workbook_BeforeClose(Cancel As Boolean) Private Sub Workbook_Deactivate() Private Sub Workbook_Open() |
• 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.
~
Convert Office 2007 files to HTML with Gmail
Convert docx and other Office 2007 files to HTML with Gmail
You need no hacks to read those Word 2007 files (docx) files without Office 2007.
Just mail all the Office 2007 document(s) to your own Gmail account and click the View as HTML link near the email attachment to convert those files into text / HTML format that can be viewed in the web browser itself.
This easy conversion method retains the document formatting (no images though) and works with docx, pptx and xlsx Open XML formats.
~
Add a .swf file to a PowerPoint 2007 Presentation
Add a .swf file to a PowerPoint 2007 Presentation
1) Open PowerPoint 2007
2) Make sure you can see the Developer tab in the “Ribbon”. If you can’t, click on the Office menu (The circle button in the top left hand corner), then click on PowerPoint Options, and make sure that you check the Show Developer tab in the Ribbon box.
3) Go to the slide you want the .swf file to appear
4) Click on the Developer tab in the Ribbon
5) Look for the More Controls button in the controls group. It is the one with a spanner and a hammer with three dots underneath it. Once you find it – click on it
6) The More Controls box will appear. Scroll down until you find Shockwave Flash Object. Click on that, then click OK
7) You will notice your cursor is now a cross, and no longer an arrow. That means you can now draw where you want your Shockwave/Flash file to appear on your slide. Simply draw with your mouse, and use the adjustment handles on the box to make sure it is just the right size and position on your slide. When you are done you should see a wireframe box with a big “X” through the middle of it
8) Now we want to link your .swf file into your PowerPoint 2007 presentation. Click on the box you just drew, then right click, and select Properties
9) In the properties box that appears, look for the Movie property, and then add the location of your .swf file (for example c:\temp\test.swf)
10) Quickly run your presentation and watch in awe as your shockwave file hits the big screen in your PowerPoint 2007 presentation
Note: This only LINKS to the .swf file, so if you email or share the presentation with others, chances are the link will break and you will need to go through the above process again to re-link the PowerPoint deck to the .swf
~
MS Outlook 2007 "Color Code"
MS Outlook 2007 “Color Code to Identify Key Messages”
Often when you open your Outlook, your are lost in a zoo of emails while you need the most important one’s immediately. What you got to do is color code the important messages so that you can identify the important emails from your seniors, clients, staff or other team members . This saves a lot of time and ensures that you don’t overlook the key messages.
Follow the steps below to color code the emails in Outlook
1: Highlight a message from a contact.
2: Choose Tools, then go to Organize. This opens a new window at the top of your Inbox window.
3: Choose the option Using Colors (found at the left of the window).
4: Pick from option, Choose color for selected message and Apply Color.
5: Additionally, you can also pick Show messages sent only to me as a way to highlight messages that are not part of a group distribution.
6: Optionally, choose Automatic Formatting (upper-right corner of window) to view coloring choices or even to apply a different font.
7: Close the Organize window when you are done. All messages in your Inbox from the selected contact are now color coded.
~
See the translation of a word in Word 2007
See the translation of a word in Word 2007
By using the Translation ScreenTip you can see the translation of most words simply by moving the mouse over them !
Translation ScreenTip works for the following languages:
* Arabic (Saudi Arabia)
* English (United States)
* French (France)
* Spanish (Spain, International Sort)
To turn on Translation ScreenTip:
1) Make sure you are on the “Review” tab of the ribbon
2) Look for the “Proofing” group
3) Click on “Translation ScreenTip”
4) Select the language you want to see the translation for, or click on “Turn Off Translation ScreenTip” to turn the translation off.
~
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.
~
Remove all Hyperlinks in MS word & Excel
Remove all Hyperlinks in MS word
You can remove it eaily with the help of Macros. Just follow some simple steps given below and see the magic.
* Open your MS word Document.
* Press “Alt+F11” – it will open the Visual Basic Editor
* Click Insert on Menu bar
* Click Module
In the new pop-up window copy following:
| Sub RemoveHyperlinks() Dim oField As Field For Each oField In ActiveDocument.Fields If oField.Type = wdFieldHyperlink Then oField.Unlink End If Next Set oField = Nothing End Sub |
Then click File and Close and return to Microsoft Word
After that Run Macro –
Tools > Macro > Macro and then Run “RemoveAllHyperlinks”
Remove all Hyperlinks in MS Excel
Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press -F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.
Copy and paste the following in new module:
| Sub RemoveHyperlinks() ‘Remove all hyperlinks from the active sheet ActiveSheet.Hyperlinks.Delete End Sub |
Close the Visual Basic editor window by selecting “Close and Return to Microsoft Excel” under the File menu.
Tools > Macro > Macro and then Run “RemoveAllHyperlinks”, this will delete all URLS on the selected worksheet.
~
Select Text Vertically
Vertically Selection of Text in MS Word
Users are more accustomed to horizontally selecting texts in lines, paragraphs etc, and when it comes to a vertical selection, most of them have no clue about it.
If you often need to use Microsoft Word for writing documents, you’ve probably come across the situation where you needed to delete the beginning of each line in a list, especially if you are reformatting a document or dealing with text pasted from another source. So here we have a tip to make vertical selection like this :
To make a vertical selection, hold down the ALT key as you drag the mouse pointer to select the text. If you want to select the first word on each line, hold down the ALT key and drag the mouse pointer up or down to highlight each word.
~
Cyber KGB 