Freeze panes in Excel

Howdy all,

Does anybody know how to freeze the top row in Excel in Applescript?

I know it can be done, but I just can’t seem to get it to work. I’m in Excel 15.19.1.

FYI the range would be from columns A thru N, or used range.

Thanks in advance,

Mark

Hi Mark,

Try this…


tell application "Microsoft Excel"
	select row 2 of active sheet
	set freeze panes of active window to true
end tell

HTH

Bingo!

Works like a charm.

Thanks! TecNik

:slight_smile: