Headers getting cropped by macro

[Phlopped]

Hi All,

I've searched everywhere for an answer to this, but can't see that anyone has managed to solve this yet.

My accounting software (SAP) runs a particular macro linked with excel, and as soon as this happens, the headers (A, B, C...) all get slightly cut off at the top of any open excel workbooks.

If I save and close them, the problem persists.

If I open a new workbook, it's back to normal.

Please help?

Thanks
Phil

 

[XLfriend777]

Hi Phlopped (Phil) - Have you tried adding formatting to your macro so that the last thing it does is reformat the headers so they fit the way you want them to? Just a thought.

 

[Phlopped]

Unfortunately, I've got no control over the macro that the accounting software runs.

It's a really annoying problem!