Code to open external workbook
Closed
G
-
24 Nov 2010 à 11:03
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 30 Nov 2010 à 10:25
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 30 Nov 2010 à 10:25
Related:
- Code to open external workbook
- Cs 1.6 code - Guide
- Samsung keypad mobile lock open code - Guide
- Tetris unlock code - Nokia Forum
- Ninja up code - Phones, PDA & GPS Forum
- Lava reset code ✓ - Phones, PDA & GPS Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
30 Nov 2010 à 10:25
30 Nov 2010 à 10:25
Hi G,
OK, so you have an open workbook where you input someone's age in cell A1.
Whenever the entered age drops below 12 you want to open a specific workbook. If this is correct use the following code, which you implement in the sheet where the age is entered (right click on sheets tab and select "view code"):
Let me know how this works for you.
Best regards,
Trowa
OK, so you have an open workbook where you input someone's age in cell A1.
Whenever the entered age drops below 12 you want to open a specific workbook. If this is correct use the following code, which you implement in the sheet where the age is entered (right click on sheets tab and select "view code"):
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
If Range("A1") < 12 Then Workbooks.Open Filename:="EnterYourFilenamesFullPathLike: C:\Excel\Master Kids 2010.xlsm"
End Sub
Let me know how this works for you.
Best regards,
Trowa
