Select Multiple Items From Drop Down List

Hello All,
I have found on Contextures, Inc website a solution, but I always have to right-click the sheet tab, click on View Code and paste the code.
Is there a way of putting the macro in a standard module so that the code is always available whenever I open Excel?
Many many many thanks in advance

Niclal

Please Login or Register  to view this content.

http://blog.johnmuellerbooks.com/201...-and-2010.aspx

Hi,
It is not about how to create a macro in general, but what to change in the code in order to work in a standard module.
Thanks

N

This link is how to SAVE the macro as GLOBAL Select Record Macro, Name it, Choose HotKey(s) Choose Personal Macro Workbook in the Store Macro In field. Save/close Macro. Open macro in VB, enter code