Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?

(image) Hey, Scripting Guy! In an Excel spreadsheet, how can I change the color of a row if there is a date stored a particular cell in that row?-- GL (image) (image) (image) Hey, GL. Some of you might have noticed that there was no Hey, Scripting Guy! column yesterday. Is that because the Scripting Guys are slacking off and shirking their...

How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?

(image) Hey, Scripting Guy! How can I delete all the worksheets in an Excel spreadsheet except for the first worksheet?-- NN(image) (image) (image) Hey, NN. Please excuse any bloodstains that might appear on your screen; as it turns out, the Scripting Guy who writes this column was involved in an … incident … this past weekend. Ah, but...

Hey, Scripting Guy! How Can I Configure Office Excel to Autosave Every 5 Minutes?

(image) Hey, Scripting Guy! How can I configure Office Excel to autosave every 5 minutes?-- KK (image) (image) (image) Hey, KK. You know, that’s a good question. As it turns out, the autosave capability in Microsoft Excel – hey, wait a minute: do you realize what day it is? Today is the first day of the 2007 Winter Scripting ...

Hey, Scripting Guy! How Can I Save an Office Excel Chart as a Picture?

(image) Hey, Scripting Guy! How can I save an Office Excel chart as a picture?-- JB (image) (image) (image) Hey, JB. You know, yesterday was a good day for the Scripting Guy who writes this column. If the phone rings at the Scripting House and if it’s for the Scripting Guy who writes this column, well, it’s never really for the ...

Hey, Scripting Guy! How Can I Change the Font Color in Office Excel If a Specified Condition is Met?

(image) Hey, Scripting Guy! In an Office Excel spreadsheet, how can I change the color of the text if the value in column B minus the value in column A is greater than or equal to 10?-- EP (image) (image) (image) Hey, EP. You know, before the Scripting Guy who writes this column started writing this column, he vowed that Hey, Scripting Guy...