View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DJL
 
Posts: n/a
Default Update workbook each time a different worksheet is selected

I need to update a workbook each time the user goes to a new worksheet either
by selecting the tab for that worksheet or by hyperlink. How can I to this
without using a macro? (using macro is ok if necessary but I am trying to
keep things simple)