Running Macros

[trainerab]

I need to run a macro when the tab (Sheet1) is selected, as opposed to
getting a user to "Click a button" - any suggestions how this can be done?

 

[EeOr]

You have posted this in an Access (microsoft database) forum rather thatn in
an excel forum which I assume is where you meant to put it. However that
said, if you put the code in the worksheet you require it to run on and
under the - Private Sub Worksheet_Activate() event this should solve your
problem. This will not run if that sheet is active when the workbook is
opened.

Jon

 

[trainerab]

Oh, sorry - still trying to get used to using this community. Many thanks
for the help - I'll give it a try