Scroll Lock Disables when I Save

[crowland]

I have Excel Office 365. My question: how do I prevent scroll lock from "auto-disabling" after I save?

Here's what happens: (1) I have scroll lock enabled on a spreadsheet, (2) I enter any new information on the sheet, (3) I click control + S to save my work, and (4) scroll lock automatically disables. I use scroll lock frequently, which I enable by way of the Fn key + Pause/Break key, which has scroll lock as its alternate function. Currently, after every time I save, I have to re-engage the scroll lock function. I searched throughout this forum for the issue, so apologies if it was previously addressed. Thanks.

 

[mrshl9898]

You could try adding this to "This Workbook"

Private Sub Workbook_AfterSave(ByVal Success As Boolean)
If Success = True Then
 Application.SendKeys ("{SCROLLLOCK}")
End If
End Sub