Auto Execute Macro

[dennis]

I'm looking to create a macro ( preferably using the macro recorder rather
than by VB code) that will refresh my database query upon opening the
worksheet.

Is this possible or just a pipe dream. I'm not adept at VB coding so that's
why the preference for the macro recorder.

Thanks in advance for any help, hints, or clues.

dennisd

 

[Dave Peterson]

Record a macro when you do it manually.

Call this macro (or rename it) Autpen

Each time you open this workbook (and allow macros to run), the Autpen macro
will fire.

 

[dennis]

Thanks, that did the job!

dennisd

Record a macro when you do it manually.

Call this macro (or rename it) Autpen

Each time you open this workbook (and allow macros to run), the Autpen
macro
will fire.