Wednesday, March 17, 2010

Honoring Saint Patrick?

As the great-grandson of Irish immigrants, Saint Patrick’s day has always been dear to my heart. It’s an opportunity to remember and celebrate my heritage and family’s lineage. Yet, after these past couple of years, I feel a cheapened by what school and American culture has taught me about such an amazing day… or better, a successful man…

Growing up, St Patrick’s day was equal to ‘green.’ Got green, life’s good. No green, endure painful pinches. I think many of us remember, or still endure, those days. Yet, my particular disappointment is that St Patrick was a man – not a color. So why do we celebrate green on his memorial day?

Do you know?

Actually the color is a symbol of Saint Patrick’s passion. No, not green eggs & ham or even a flamboyant wardrobe. His passion for sharing freedom. As a teenager, he was sold into slavery by a group of bandits who raided his village. During this difficult trial, he drew near to God and underwent a transformation in his heart. His passion became to share the freedom of Jesus Christ to everyone who would open their mind and humbly receive the gift of salvation from a power higher than themselves.

But, what about the green???

Paul stated in his letter to the Romans, “For since the creation of the world God's invisible qualities—his eternal power and divine nature—have been clearly seen, being understood from what has been made, so that men are without excuse.” In the same manner St Patrick used a simple clover leaf to demonstrate the truth of this verse. One of the most difficult concepts of God to grasp is how He is THREE distinct persons, yet ONE GOD. Moses said, “Hear O Israel, the Lord, our God, the Lord is one."

A very widespread, living tradition tells ... When trying to explain the mystery of the Holy Trinity to his hearers, he saw the trefoil growing on the green sod beneath his feet, and taking it up in his hand, he pointed out how the triple leaf sprang from the single stem, even as the Three Divine Persons, really distinct from each other, were yet One in the unity of the Godhead. It was, of course, an imperfect, but yet, … very apt illustration … and made St. Patrick's Shamrock the immortal symbol of Ireland's faith and nationality.’ – Taken from Harvard College, ‘The life and writings of St. Patrick"

And here are the man’s famous words, translated from Gaelic of course:

Christ with me,

Christ before me,

Christ behind me,

Christ within me,

Christ beneath me,

Christ above me,

Christ at my right,

Christ at my left,

Christ in the fort,

Christ in the chariot seat,

Christ in the poop deck,*

Christ in the heart of everyone who thinks of me,

Christ in the mouth of everyone who speaks to me,

Christ in every eye that sees me,

Christ in every ear that hears me.

I bind to myself today

The strong virtue of an invocation of the Trinity,

I believe the Trinity in the Unity

The Creator of the Universe.

Salvation is of the Lord,

Salvation is of the Lord,

Salvation is of Christ,

May thy salvation, O Lord,

be ever with us.

* Wikipedia: AKA the Stern Deck, name originates French word for stern, la poupe. In sailing ships, an elevated position ideal for both navigation  and observation of the crew and sails..

Saturday, March 13, 2010

Excel: Quick Add New Color Comment XLA

It's been some time since I've made a post so I've decided to upload some Excel xla file add-ins that I've made for various reasons over the past couple of years. Enjoy!

Here's a link to download my AddComment XLA file. It allows you to press Ctrl + Shift + A to quickly made a decent looking comment within your cells! Also, it allows you to easily change the color of the comment. (Note: Use the toolbar shortcut to make your first comment.)

What's an xla file? It's basically a way of sharing the code to automate some functions in Excel. In this case, I did the work and you reap the benefits! Well... me too!

How do I install it? The easiest way I've found is to navigate to where you can Manage Excel Add-ins. Basically the screen below. (The way to get there depends on your version of Office.) Once you are there, click Browse... and it will open a normal windows explorer screen. Right-click in this screen to paste the .xla file from within the zip file. Highlight the file to add it to your list then click the checkmark to turn it on. All my add-ins use some very neat code I put together from a couple of VBA gurus to automatically add toolbar shortcuts.

One last note is that I offer these add-ins free of further work. That means that I'm not doing bug fixes and I'm sure some exist since I developed these in Excel 2003 and have refined some slightly for 2007. I still have many ideas on what could be done, but not the time to complete them! But, unlike many other xla coders, I did not lock or password protect these files. The source code is yours to do whatever you want with and modify as you like!

Please let me know if you've improved any of them and pass them back my way! Thanks!