Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to automatically trigger the vba coding by opening worksheet?
The following code is stored under specific worksheet, whenever the worksheet
is opened, it required to update all links and do all the calculation for each cells. For the given code, it requires to manually press F2 and enter to update and trigger the rest of coding. However, the value within cell A1 is calculated by formula, without manually pressing, the rest of coding will not be performed without triggering cell A1, so does anyone have any suggestions on how to trigger the rest of coding without manually update the A1 cell's value? Thank everyone very much for any suggestions Eric If Target.Address = "$A$1" Then On Error Resume Next Set myPic1 = ActiveSheet.Pictures("PicAtB10") Set myPic2 = ActiveSheet.Pictures("PicAtE10") Set myPic3 = ActiveSheet.Pictures("PicAtH10") On Error GoTo 0 If Not myPic1 Is Nothing Then myPic1.Delete If Not myPic2 Is Nothing Then myPic2.Delete If Not myPic3 Is Nothing Then myPic3.Delete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with automatically opening another worksheet | Excel Discussion (Misc queries) | |||
Macro To Run Automatically For Any Worksheet Upon Opening Of THe F | Excel Discussion (Misc queries) | |||
One particular worksheet always automatically opens when opening E | Excel Discussion (Misc queries) | |||
Opening a worksheet automatically at start up of computer | Excel Worksheet Functions | |||
Run macro automatically on opening of worksheet | Excel Worksheet Functions |