Notice: WC_Cart::get_cart_url is deprecated since version 2.5! Use wc_get_cart_url instead. in /home/swatipaliwal/public_html/excelcrazy.com/wp-includes/functions.php on line 3839
Excel Crazy

A series Macro Examples

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

December 31, 2011
top
 

© LOKESH PALIWAL 1987 - 2017

Reporting Solutions | Data Consulting | Analytics Training