Search This Blog

Showing posts with label Computer Tips and Trick. Show all posts
Showing posts with label Computer Tips and Trick. Show all posts

Monday, February 15, 2010

Naming sheets in Microsoft Excel

Use the ribbon starting with home, then navigate to cell, press space, then tab to format, press space, then arrow down to rename sheet and press space.

- or -

Use the JAWS cursor to find the tab "sheet 1" under the spreadsheet and press right mouse button on it to bring up a context menu.
the Insert+Shift+s shortcut

Sunday, February 14, 2010

ACCESSEBLE BURNER

Look at

www.deepburner.com

The free version will burn data cd's and dvd's and audio cd's. it is
lightweight and accessible out of the box and you can just copy and
paste to put together your disk layout.

Tips Use Word on Excel

Sometime we hard to write on excel because limited Tools on Excel
compare we write on Word, but don’t wory we can use word on excel.1.
Open Excel
2. Click Tab Insert



3. Click Object

4. Choose Microsoft Office Word Document, click OK



5. Arrange the weight as we like and the like usual on word.

6. And if you want exit just Double click on Excel and if you want to
edit just Right click choose Documents Object | Edit.

Tips Showing Message When Word Doc Open

Want leave a Message for your remainder, it’s will open when your word
doc it’s open then :
1. Open the file you insert message.
2. Click Developer | Visual Basic / ALT F11.



3. Double Click This Document.

4. Type this code
- For the message :
Sub LihatPesan()
MsgBox “message” Exmple “Tolong Kirim Email ke Direktur”
End Sub



- To call message when open :
Private Sub Document_Open()
Call LihatPesan
End Sub

5. Save as Word Macro – Enabled Documents on Trusted Folder.

6. Now for test close the doc and open again.

Make Your Own Bullets on Word

Don’t want use standard Bullets, well you can use ClipArt as Bullets.
It’s very easy to do it :
1. Open Word
2. Click Bullets | Define New Bullets.

– Click Symbol use symbol as Bullets



– Click Picture if you want ClipArt as Bullets. To use a ClipArt Click
Picture and click Impor find ClipArt on folder C:\Program
Files\Microsoft Office\CLIPART\PUB60COR, after finished click Ok.


3. And if you want add Bullet to library bullets, Click Bullets, right
click the Bullets we make and choose Add to Library

Format Color for Number with VBA

Sometime we want make format for number, such if < 100 then is red, we
can make with help VBA Excel:
1. Open Excel and Finished the data
2. Click Developer | Visual Basic /ALT + F11.

3. Click Insert | Module.

4. Type this code,
- Sub Nameprosedur() and press Enter, example : sub Warnai()
- Dim Cell As Range (declare cell to Range)
- Use For Each for loop : For Each Cell In Selection
- Use If Elseif :
If Cell.Value < 100 Then
Cell.Font.Color = vbRed
ElseIf Cell.Value >= 100 And Cell.Value <= 499 Then ‘gunakan and untuk
dua syarat
Cell.Font.Color = vbBlack
Else
Cell.Font.Color = vbBlue
End if
- and type for close the for : Next Cell


5. Go Back to Excel and Click Develepor | Macro



6. Click Name Macro, click Option


7. Make Description and Shorcut key



8. For test Highlight cell and use Shortcut key-nya and save as Excel
Macro-Enaled(xlxm) or Add -in.

NewsFlash : Cool ScreenSaver

Here are link some cool Screensaver

Dolpin

Living Marine Aquarium 2

download from
http://www.download.com/

China May Send SMS Mesum Conditional

Fino Yurio Kristo - detikinet

illustration (ist) Beijing - Government of China recently issued
regulations that threaten the bawdy SMS spreaders will get punished.
Apparently, that rule makes a number of married couples or lovers
exchanging SMS fears tender.

Related to these fears, the authority was trying to convince China that
SMS bawdy nuances between couples or friends will not lead any
sanctions. But the deal between the sender and the recipient SMS nobody
bothered.

"If a friend was disturbed by the pornographic messages, it becomes
possible violations, but if this love between friends send such SMS, of
course there is no violation," said Hu Yunteng, judicial officials in
China who detikINET quoted from the AFP, Monday (8 / 2 / 2010).

Explained that Yunteng legitimate if between friends exchanging vulgar
SMS with the intent to joke with each other. It will not be brought
into the realm of law.

Target rules are the criminals who deliberately spread the message to
the public porno. They are going to get caught doing administrative
penalties.

News eradication of pornographic content from China endless.. Officials
there are very keen to uphold the rules, 5400 proves as much local
police arrested a suspect in the year 2009, related to the case of
pornography online.


source :
www.detikinet.com