Macro to check Macro Name and Active Workbook before running

[robertguy]

Macro to check Macro Name and Active Workbook before running
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Hi,
<o></o>
Can anyone please advise me of the macro code I need for the following :-
<o></o>
When a macro is select to run (from PERSONAL.xls) the users is prompted via a message box “Are you Sure you want to run the XXX macro i.e. the name of the macro on the active work book i.e. the workbook which is currently active”.
<o></o>
Which would then allow the user to answer in the usually way i,e. vbYesNo etc
<o></o>
<o></o>
<o></o>
Any assistance would be greatly appreciated
<o></o>
<o></o>
Many thanks in advance
<o></o>
<o></o>
Rob
<o></o>
N.B Excel version 2003

 

[niceguy_jay]

you will need to add this code at the start of each macro....

MsgText = "Do you want to continue running THIS macro?"
Style = vbYesNo
Title = "Run Macro"
Response = MsgBox(MsgText, Style, Title)
If Response = vbNo Then Exit Sub

and replace THIS with the name of the macro.....

I believe this is the only way it can be done...