Category: VBA

Office PDF/XPS Addin

One of the big things that Office 2007 was supposed to bring was the ability to save to a PDF file, without getting extra software. Somewhere along the line, they decided to make this feature an Add-in, which can be

Read More »

Force User To Enable Macros

Introduction: There are times when you may need to force your users to enable macros to work with your files. Maybe you've programmed some special functions to work with your file, for example. Unfortunately, Office's security settings can get in

Read More »

My code has been used by NASA…

Now this is straight out of the "How cool is that?" file. 🙂 Last week, I got an email asking a question about adapting the Print Multiple Worksheets to a PDF article that I have on my site so that

Read More »

Using a Treeview Control

This is a tutorial on the creation of a simple Treeview control on an Excel userform. For the purposes of this example, we'll be populating the Treeview control with worksheet names and the addresses of cells with formulas in them.

Read More »