Running Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Oh, sorry - still trying to get used to using this community. Many thanks
for the help - I'll give it a try
 
Back
Top