Want user to select macro enabled manually

Hi all,

I need a code for, user should select whether the macro shoyld be enabled from 'PERSONAL.XLS' workbook with a Msgbox - YES and NO.

i.e. If user selects YES the macros should be enabled from PERSONAL.XLS workbook,

if user select NO the macros should be disabled, leaving a normal excel sheet.



Thanks in Advance.

Why, to what purpose ?

Bcoz some users want to run macros, some others wont. So i need a msg box with yes and no option. Depending on that selection the system should enable or disable macro,


Can u plz help in this?

Looks like a circular answer.