Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bmbarnett
Engaged Sweeper III
This might be impossible to do, but I thought I would ask. Does anyone know of a way to lock the top row of the report in Lansweeper? I know we can in Excel, but it's a manual process of opening it and clicking the button and then saving. The harder part is remembering to do it. Any idea's or tricks to automate would be appreciated.
1 REPLY 1
RCorbeil
Honored Sweeper II
I have to assume that you're asking about locking the first row in Excel, because the titles in LANSweeper reports are already locked at the top.

Suggestion: make yourself a global macro that jumps to A2 and then freezes the row above, then create yourself a quick-access toolbar button that runs the macro.

If you want to record the macro: F5, A2, Enter, Alt+W, F, F. The result should look like this:
Sub freeze_top_row()
Application.Goto Reference:="R2C1"
ActiveWindow.FreezePanes = True
End Sub

You'll still have to remember to invoke it, but it'll be just a click away.

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now