HypRetrieve error -5 (SS_NOT_LOCKED)

Summary

HypRetrieve error -5 (SS_NOT_LOCKED)

Content

Hello,

Right now I'm migrating Applications from Essbase API to Smart View.

Code:

Working one (old)

X= EssVRetrieve(sheetName, Null, 1)

I have tried to change it to smartview so I have used HypRetrieve as there is no need to set Range.

X = HypRetrieve(sheetName)

When I'm trying to execute it, I'm receiving as a result '5'

According to documentation:

SVError = -5 Then

    MsgBox (“Smart View Error: SS_NOT_LOCKED” & vbCrLf & vbCrLf & “Description: The spreadsheet is not locked.”)

On EssVRetrieve, there was possibility to set up the flag (1) and it worked.

How can I lock the sheet?