Sharing Personal Macros / XLSTART Folder

Occasional Visitor

Hello, 

 

I have a couple macros in my XLSTART/Personal file. I heard that sharing the Personal file is potentially dangerous - is this true? 

 

What is the safest method of sharing Personal macros to another computer?

 

Thanks. 

1 Reply

@BlueBIJ 

Your PERSONAL.XLSB workbook should be used by one person at a time only, so it is not a suitable candidate for sharing.

I'd create an add-in (.xlam) and install that on each computer using File > Options > Add-ins.