I'm trying to get a macro (named Refresh) to run whenever a worksheet is
opened. I've tried using
Private Sub Worksheet_Activate()
Refresh
End Sub

as was suggested in other posts, but this doesn't seem to work.

And this macro is placed in the worksheet? In other words, right-click the
worksheet tab and hit View--Code, and you can see it there? Also, what is
it you're trying to refresh?

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"MLT" wrote in message
...
I'm trying to get a macro (named Refresh) to run whenever a worksheet is
opened. I've tried using
Private Sub Worksheet_Activate()
Refresh
End Sub

as was suggested in other posts, but this doesn't seem to work.

The macro is in the worksheet. It runs a query that pulls in data from an
Access database. The macro itself works fine if I run it manually.

Nevermind, I figured it out. Since this was the only worksheet, I should
have used Workbook_Open() instead of Worksheet_Activate().