Macro (SelectLastPeriod) failure

SUGGESTED

Good Morning! 

Someone kindly assist with below error.

All our macros is enabled on Excel as per trouble shooting documents on kb.pastel