A series Macro Examples

Share Now


Activate Event

Activate event occur when workbook, worksheet, chart sheet or embedded chart is activated. Suppose you have worksheet with more than one pivot tables and every time you want you go to the worksheet, data to be refreshed. The below given code will help you to accomplish the task.

 

Private Sub Worksheet_Activate()
 
Dim Intcount as interger
For intcount = 1 to Activesheet.PivotTables.count
activesheet.PivotTables.Intcount.PivotCache.Refresh
Next Intcount
 
End Sub



Share Now
October 9, 2011

Tableau Training in Delhi

All Rights Reserved. EC Analytics Consulting 2014 - 2019.

NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy

Drop us a Query

Call Us: +91 8826547882

Drop us a Query