ScrollArea not working

I am creating an Excel dashboard and I trying to lock the screen area. This is the first time I am trying to use this feature. My file is Macro-enabled and saved as .xlsm and I am using Microsoft 365 Personal on Windows 10 Pro. Below are the options I tried to lock my screen, however, none of them are working:

1. Went to Developer -> Properties -> In Scroll.Area, I entered A1:W25 which is where I want to lock, then closed the Properties box. However, it didn't work
2. Used VBA, added the following code in ThisWorkbook editor:

Private Sub Workbook_Open()
Worksheets("MyWorksheetName").ScrollArea = "A1:W25"
End Sub

Then saved the file, and reopened it, however, this didn't work as well

3. I tried contacting Microsoft Support, and we tried diagnosing this problem, tried both of the above solutions, updated Microsoft Excel, checked all the settings, however, this didn't work as well.

Can someone help me with this issue?