I want to create several styles for headings etc. in my workbooks which can
be used in every workbook I can create.

One option is to save all my styles in one workbook and ensure this workbook
is kept open and use the 'merge' feature in the styles dialog to merge the
styles to my new workbook. However, I believe this can also be done by
saving them into the personal workbook.

I have attempted to use the personal workbook in the past but presume i did
something wrong because every time I opened Excel, the personal workbook
opened and I had to hide it each time.

What's the best way to do this? Merging or Personal Workbook?

Thanks.
Louise