How to carry over freeze panes function into temporary file from VBA

[gillyr7]

I have a code below that works great for sending different ranges from the same sheet to different email addresses. It creates a temporary file as the attachment in the email.

One thing that would be great to have is to be able to freeze panes of the temporary file headers. There are the same headers at the start of each range, and it would be nice if each row of headers would have the freeze panes function in each temporary file.

Is this possible? If not for multiple files, can the first row of headers (row 1) follow over to the first temporary file?

Any help would be greatly appreciated.

[Izandol]

I think you have forgotten your code?

[xladept]

It creates a temporary file as the attachment in the email.

You could use a template that had the freeze panes.

[gillyr7]

Please Login or Register  to view this content.

[gillyr7]

Creating a template would probably work for just one email, but could you get that to work when many emails are created from many ranges in the file? This could end up creating 600 emails, and in my mind, you would need 600 templates for that. Is there a way around that?

[Izandol]

Perhaps simply:

Please Login or Register  to view this content.

[gillyr7]

Adding that verbatim did not freeze panes in my created files, but when I changed that

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

The freeze panes followed through to the temporary file, however, it started in row 18. So 18 was stuck while 19 and below could scroll. I am still new to this, is there a way to freeze at row 2, so rows 1 and 2 are stuck in each file?

[Izandol]

That should be achieved with:

Please Login or Register  to view this content.

but it seems your code is not behaving.