Category: VBA

The best line of VBA ever

Okay, I'll admit that you probably have to be a parent of a young child to agree with this, but here it is: [code]Application.Speech.Speak Target[/code] This all started when I showed my kid how fast the computer could count to

Read More »

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 »