Thursday, October 13, 2016

Happiness Quotes!

Received in mail from a friend and want to add it in my blog, Credit got to writer.

Happiness is a mental or emotional state of well-being characterized by positive or pleasant emotions ranging from contentment to intense joy.


  • “People are just as happy as they make up their minds to be.”
  • “I'm choosing happiness over suffering, I know I am. I'm making space for the unknown future to fill up my life with yet-to-come surprises.”
  • “Happiness is not the absence of problems, it's the ability to deal with them.”
  • We become more successful when we are happier and more positive.
  • The grand essentials to happiness in this life are something to do, something to love, and something to hope for.
  • Only one thing has to change for us to know happiness in our lives:  where we focus our attention.
  • We learn the inner secret of happiness when we learn to direct our inner drives,  our interest and our attention to something outside ourselves.
  • Now and then it's good to pause in our pursuit of happiness and just be happy.
  • Happiness belongs to the self-sufficient.
  • Happiness is the meaning and the purpose of life, the whole aim and end of human existence.
  • Tell me what you feel in your room when the full moon is shining upon you  and your lamp is dying out, and I will tell you how old you are, and I shall know if you are happy.
  • Happiness is living by inner purpose, not by outer pressures.
  • Every gift from a friend is a wish for your happiness.
  • It’s a helluva start, being able to recognize what makes you happy.
  • The secret of happiness is not in doing what one likes, but in liking what one does.
  • There are short-cuts to happiness, and dancing is one of them.
  • The art of being happy lies in the power of extracting happiness from common things.
  • While we are focusing on fear, worry, or hate, it is not possible for us to be experiencing happiness, enthusiasm or love.
  • Happiness is good health and a bad memory.
  • To be happy, drop the words 'if only' and substitute instead the words 'next time'.
  • It is only possible to live happily ever after on a day to day basis.
  • Growth itself has the germ of happiness.
  • Delight in mediation and solitude. Compose yourself, be happy. You are a seeker.
  • Happiness comes when your work and words are of benefit to yourself and others.
  • May everyone be happy and safe, and may their hearts be filled with joy.
  • To enjoy good health, to bring true happiness to one’s family, to bring peace to all, one must first discipline and control one’s own mind. If a man can control his mind  he can find the way to Enlightenment, and all wisdom and virtue will naturally come to him.

Friday, October 7, 2016

Create User Define Function and Macro as an Add-in


We work lot in excel and manage our work with functions and macros. I am here creating the process that will save your time and effort to re-create again and again the same functions or macros.

Here we are going to create Add-in that will automatically load when you open your excel, and the function will be available all the time. So let's start.

Step 1: Quickly create an empty add-in for excel


  1. Open excel and Save a blank workbook as a Excel Add-In (*.xlam) in your Add-In folder (%UserProfile%\AppData\Roaming\Microsoft\AddIns)
  2. I named it PersonalAddIn.xlam (Save it with any name you like)
  3. Click Office button.
  4. Click "Excel options" button.
  5. Click "Add-Ins" tab.
  6. Select "Excel Add-ins" from manage dropdown list and click GO
  7. Click "Browse" button
  8. Select the (.xlam) file that you just saved in step 1
  9. Click OK (Make sure you enable)



Step 2: Add custom functions and macros to your personal add-in

  1. Go to the Developer Tab on the ribbon.
  2. Click "View Code"
  3. Click on the project panel you see VBAProject (*.xlam)
  4. Click Insert Menu --> Module
  5. Copy and paste custom functions and macros to code window.


That's it... we are done.

Step 3: Use your user define function

  1. Go to the cell
  2. Click "Insert Function" in formula bar
  3. Select category "User Defined"
  4. Select your custom function
  5. Click OK


Step 4: Use your user define Macro

  1. Go to "Developer" tab
  2. Click "Macros" button
  3. Select/Type the macro name
  4. Click "Run"


Hope this will help you in you daily work, In case of any query you can write to me. Thanks for reading.

Wednesday, October 5, 2016

Windows Registry Tips

A small tweak which disables processing of autorun.inf to protect your PC from usb autorun viruses.

Windows Registry Tips

Remove Language Bar from Taskbar
[-HKEY_CLASSES_ROOT\CLSID\{540D8A8B-1C3F-4E32-8132-530F6A502090}]
@="Language bar"
"MenuTextPUI"="@%SystemRoot%\\System32\\msutb.dll,-325"


Allow Internet Explorer 7+ to open direct links to swf files (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BLOCK_LMZ_SCRIPT]
"iexplore.exe"=dword:00000000


Disable the Turn off computer button on the Welcome screen (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System]
"shutdownwithoutlogon"=dword:00000000

Disable USB Autorun to Save PC from USB Viruses (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\IniFileMapping\Autorun.inf]
@="@SYS:DoesNotExist"

Disable Writing to USB Drives (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies]
"WriteProtect"=dword:00000001

Enable Writing to USB Drives (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies]
"WriteProtect"=dword:00000000

Note: Modifying the registry can cause serious problems that may require you to reinstall your operating system. Use the information provided at your own risk.