Jake Blackmore
Board Regular
- Joined
- Nov 24, 2014
- Messages
- 200
Hello all,
I've created the following macro to run on a worksheet deactivation event in a file that is given to my client:
They are running Excel 2010 and a colleague using the same network also struggled with the issue. The issues seems to stumble on being unable to find the deactivation event in the library.
Really would appreciate any guidance given,
Thank you,
Jake
I've created the following macro to run on a worksheet deactivation event in a file that is given to my client:
Code:
Option Explicit
Private Sub Worksheet_Deactivate()
Dim lngResponse As Long
If Not Me.Range("rng_OriginalCurrency").Value = Me.Range("rng_CurrencyOption").Value Or Not Me.Range("rng_OriginalTeam").Value = Me.Range("str_ActiveTeam").Value Then
Me.Range("rng_OriginalCurrency").Value = Me.Range("rng_CurrencyOption")
lngResponse = MsgBox(Prompt:="Are you sure you wish to refresh the CCY Cummary?" & Chr(10) & "Please note all changes made to CCY Summary will be overwritten", Buttons:=vbYesNo + vbQuestion, Title:="Refresh CCY Summary?")
If lngResponse = 6 Then
Call ApplyPvtFilters
End If
End If
End Sub
They are running Excel 2010 and a colleague using the same network also struggled with the issue. The issues seems to stumble on being unable to find the deactivation event in the library.
Really would appreciate any guidance given,
Thank you,
Jake