Smartview VBA in HFM Data forms - cannot set POV

Summary:

Does anyone have experience using VBA functions within a HFM web data form loaded via SmartView? Specifically, if it's possible to directly set the POV via an Excel VBA Macro in a HFM data form?

Content (please ensure you mask any confidential information):

This is for an on-premise HFM application, though the actual question lies with SmartView and Excel. As background, they want to begin developing Excel Macros for their applications that can instantly set the POV to specific members, but in testing these are always returning error codes or simply not changing the POV in the sheet. We tested the same macros in an ad-hoc grid which did not cause the same errors and updated the POV as expected - leading us to wonder if the issue lies with the data form itself or if we've overlooked something required for using the