Welcome to our links section. In this section we provide you with some of
the best links on the net so that you can quickly jump to solutions that
can shed some light on some problems you may be facing.
We hope that these links will help you find what you're looking for.
We wish you an enjoyable trip through these links
The MS Office Guru Team
Thursday, December 06, 2007 Printing Worksheets To A PDF File (Using Early Binding) This article contains code examples to print worksheets to PDF files.
Thursday, September 15, 2005 Selecting all Unlocked Cells As you probably know, when a worksheet is protected, only the unlocked cells can be changed. You may want to apply different formatting to the unlocked cells, or simply ensure that the correct cells are indeed unlocked...
Thursday, August 25, 2005 Customize the Word 2000/2002 File Operations Places Bar In the file operations windows (File > Open; File > Save) Word offers a pre-configured Places Bar with five places where you might want to store documents. These places can be personalized, and, by reducing the size of the icons, the number may be increased. Thus, for example...
Wednesday, July 27, 2005 Call the Windows File Open/Save dialog box This can be done by either using the Common Dialog Control in Access 97 or by using the APIs defined for this purpose...
Wednesday, July 13, 2005 Displaying a Chart in a UserForm This is a cool trick on how to show a chart in a UserForm...
Friday, July 08, 2005 Password Protecting Web Pages using FrontPage Normally FrontPage is not seen as a good authoring tool. However, this perception has been changing. Here's a link that show you how to password protect you webpages...
Wednesday, July 06, 2005 Conditional Formatting Validation Macro This is a pretty cool Conditional Formatting Validation using a Macro in Excel. A must see, thus it has been rated with 5 stars...
Wednesday, July 06, 2005 Creating A List of MP3 Files Here's an Excel application that generates a list of MP3 files, and displays them in a handy pivot table report.
Thursday, June 30, 2005 Avoiding unwanted capitalization Word is configured, by default, to automatically capitalize sentences, but this often produces unwanted results - such as cc: being converted to Cc: …
Sunday, June 26, 2005 Array Functions This is an Excel Tool that contains several function and sub procedures for manipulating arrays and worksheet ranges. If you are an array fan, you’ve go see this…
Sunday, June 26, 2005 Hypocycloidal Chart At this link you will be able to download a workbook with an amazing chart plotting-tool that generates incredible hypocycloidal charts! A must see for any Excel charting enthusiast…