Saturday, May 13, 2017

How to remove all hyperlinks in Ms Powerpoint presentation file with one click

When you copy-and-paste a picture from your local disk or from Internet source to your Ms Powerpoint presentation slide, you might unconsciously also created an embedded hyperlink inside the picture which link back to its source.

You might want to remove/delete all those hyperlinks in your presentation slides, as you don't want them to surprise you (and your audiences) in the middle of your presentation, in case you accidentally clicked on the picture and it starts to open up your web browser, searching and connecting to the source of that picture.

Well, you can remove the hyperlinks one by one, by right clicking on the picture and select "Remove hyperlink" from the popup menu.

However, it will be extremely tedious and inconvenient, as Ms Powerpoint unable to tell you which picture got hyperlink and which one doesn't have. You will need to check and unlink all of them one by one, and you are very likely to miss out some of them.

Here is a method which enable you to remove all those hyperlinks in the entire Ms Powerpoint presentation file at one go.

In this method, you create a simple macro program to automatically remove all the hyperlinks one by one at the background, and report back how many hyperlinks removed when it finished. When you save your presentation file, the macro won't be saved together so your file remains clean.

Step 1: Open your Ms Powerpoint presentation file.

Step 2: Press Alt+F8. That will open the Macro window.

Step 3: Enter "Rmlinks" as macro name (or any name you like, as it is for temporary use only), and click the Create button.

Step 4: Copy and paste the following codes into your macro editor.

Sub Rmlinks()
 Dim slide As slide
 Dim index As Long
 Dim counter As Long
 counter = 0
 For Each slide In ActivePresentation.Slides
    For index = slide.Hyperlinks.Count To 1 Step -1
       counter = counter + 1
    Next index
 Next slide
 MsgBox ("Removed " + CStr(counter) + " link(s).")
End Sub

Step 5: Press the F5 button on your keyboard to run. If it pop up another window, just click on the Run button to run.

Step 6: Press OK after seeing the result of how many hyperlinks successfully removed.

Step 7: You can now close the Macro window by clicking on the [X] in red at its top right corner, the same way you close any other windows.

When you save your file, the following dialog box might appear. Just press the "Yes" button.

Now, you have your Ms Powerpoint presentation slides the same as before, but clean from all the unwanted hyperlinks.

Saturday, May 6, 2017

The 5 Steps required to make your right decisions

Every now and then, we make decisions. Some are just small decision with minimal future effect, while some are significant and will change the history.

While we are aware that make the right decision is important, all of us cannot escape from having numerous occasions of making decisions which we regret later.

Patrick McDaniel of has written a report called "The Scientifically Proven 5 Step Process To Making Better, More Successful Decisions" which you can freely download here.

Below is my summary of what I've learnt from McDaniel's report.

1. Be open minded to all possibilities and options

  • If you have bias, your favoured choice could be a disaster.
  • Listen carefully to your inner self, or your God's guidance.
2. Expand your choices
  • Do not rely solely on single option, because that single option has 65% chance of likelihood leading to a bad decision.
  • Instead of looking through binoculars and fixating on the single, apparent option before you, it is better to take a 360 degree, 3-dimensional panoramic view of the situation and your possibilities.
  • Ways to increase your perceived options including:
    • Talk to others
    • Consider your opportunity costs
    • Remove the current option and think about what other way you could have
    • Mix and match possible options
3. Expose your bias
  • Don't be fooled by your own confirmation bias by:
    • Arguing the opposite with yourself
    • Seek a contrarian
    • Ask tough questions of your favoured option
    • Run a test to dip your toe in the water
4. Escape your emotion
  • Beware of your exposure effect (automatically and instinctively cling to the familiar).
  • Your fear of loss can be irrational.
  • You can be more rational by:
    • Prospecting the future
    • Defending your decision
    • Counselling others
5. Prepare for the worst
  • Beware of overconfident bias.
  • Run a premortem.
  • Set a tripwire, which could be time based or situation based.

Sunday, April 30, 2017

Hush Puppies Apparel warehouse sale 2017 @ Puchong

Redina Malaysia Sdn Bhd located at Jalan TPK 2/3, Taman Perindustrian Kinrara, Puchong, Selangor is having the Hush Puppies Apparel warehouse sale now, offering discount as high as 80%!

As usual, they have put up a big red Hugh Puppies balloon on top of the air of the location for you to locate their direction when you are near to them. You will also see banners along the roadside of Bukit Jalil Highway (a.k.a. Puchong-Sungai Besi Highway or Federal Route 217).

This promotion started on 28 April 2017 and will end on 7 May 2017. The opening time is 10am - 7pm daily.

If you purchased more than RM200 in a single receipt, you will get a free drinking bottle as gift.

If you pay using your Public Bank credit card, you will immediately get an additional 5% discount for all the items in your receipt. If your payment is above RM400 in that receipt, you can also claim a set of Easy Lock container at the Public Bank booth near to the entrance.

Items on sale are apparels for men, women, children and todders, which include Hush Puppies shirts, casualwears, pants, innerwears, underwears, socks, etc. There are also accessories, bags, luggage, stationeries, bed & bath, etc.

For the apparels, I found that for this round of Hush Puppies apparel warehouse sale, there are more items for women and girls than for men and boys.

Hint: Click on the "Older Posts" link to continue reading, or click here for a listing of all my past 3 months articles.