how to write and record macros to customize your workbook, and how to run macros to automate and speed up repetitive tasks.

Buttons (or scroll bars or other objects) do not work at all. Clicking a button does nothing. All of the buttons (and other objects) in my workbooks are tied to macros. You must allow Excel to run ...

The macro READIT then uses the %BQUOTE function to allow a %IF condition to accept the unmatched single quotation mark: data test; store="Susan's Office Supplies"; call symput('s',store); run; %macro ...