Excel Pragma

Excel Pragma http://www.chalouhis.com/XLBLOG Excessive Excel Sun, 04 Nov 2007 13:47:41 +0000 http://backend.userland.com/rss092 en Deciphering the Excel 2003 Custom Number Formats For the most part, the different number categories in the Category list box and their types are pretty easy - if not a breeze - to comprehend. For most people, that self-assured feeling goes right out the window as soon as they click the Custom category and get a load ... http://www.chalouhis.com/XLBLOG/archives/2006/07/30/example-note-2/ Scroll Protection Without Protection You can protect a spreadsheet so that data is shielded from inadvertent entries.There is another way to set up a scroll area that does not involve protection.Open the Control Toolbox (right-click any existing tool bar) and click on the Properties icon. In the Scroll Area text box, type the ... http://www.chalouhis.com/XLBLOG/archives/2006/07/11/scroll-protection/ Great new online community Hi, everyone! Cool, new online resource to mention today… The Microsoft Work Essentials Web site has started new discussion forums for those who use Office in finance, sales, marketing, office administration, project management, and IT roles. You can post questions in the Work Essentials Community Forums and moderators will help ... http://www.chalouhis.com/XLBLOG/archives/2006/07/10/great-new-online-community/ Excel Drawings This has been on the blogs for the past two days : 58 Days Worth of Drawing Exercises in Microsoft Excel . I have yet to see Excel play mp3s (with visualisations?). http://www.chalouhis.com/XLBLOG/archives/2006/04/29/excel-drawings/ Dashboard Templates - Excel User Interesting dashboard formats and ideas at Excel User, very handy for consolidated portfolio views for example. Different layouts are presented in the gallery. if you don’t want to waste time (or space), check the extreme dashboard : Postage Stamp Report. http://www.chalouhis.com/XLBLOG/archives/2006/03/08/dashboard-templates-excel-user/ Free Excel Spreadsheet - Peacock Capital Peacock Capital specialises in solving the cash flow challenges of Small/Medium Businesses, Government Vendors and Individuals with alternative financing solutions.[Link] The amount of models on this site is impressive ranging from Corporate Finance and Focused Valuations models all the way to Option Pricing. http://www.chalouhis.com/XLBLOG/archives/2006/03/08/free-excel-spreadsheet-peacock-capital/ Regular Expressions Regular expressions are a system for matching patterns in text data, which are widely used in UNIX systems, and occasionally on personal computers as well. They provide a very powerful, but also rather obtuse, set of tools for finding particular words or combinations of characters in strings. [Link] http://www.chalouhis.com/XLBLOG/archives/2006/03/08/regular-expressions/ Color Picker Another colour link , but this time for an “essential” tool : colour picker. http://www.chalouhis.com/XLBLOG/archives/2006/02/13/color-picker/ Color Palettes I’ve been looking for a brown palette. I still haven’t found a nice one but found a couple of sites which will definitely come in handy next time I need colours. 1 – Site Blender – Palette/Theme generator 2– Color Mixers – Palette/Theme generator http://www.chalouhis.com/XLBLOG/archives/2006/02/13/color-palettes/ Another article on migrating VBA to VSTO Here’s another article from Microsoft’s Office Developer Center : Convert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005 Tools for Office . Why Migrate to Visual Studio 2005 Tools for Office : Improved development productivity Improved security model Easier deployment and versioning Added functionality from the Microsoft .NET Framework Improved code reuse Easier integration Here’s ... http://www.chalouhis.com/XLBLOG/archives/2005/04/21/another-article-on-migrating-vba-to-vsto/