Activate VB Macro when opening excel file

**rizmomin** · 02-21-2012, 11:07 AM

Hi:

I have VB Code (macro) in sheet2 of excel file.
I need to code which will ask if i want to run the macro. ( Y/N)

Please help me with this simple solution.

Thanks

RM

**Richard Buttrey** · 02-21-2012, 11:20 AM

Hi,

Immediately before your macro code

Please Login or Register  to view this content.

**rizmomin** · 02-21-2012, 11:28 AM

Hi Richard:

Thank you for your qucik help.
I meant was:

when i go to sheet2, it should ask if i want to run macro?

Sorry for misunderstanding.

RM

**Richard Buttrey** · 02-21-2012, 11:45 AM

In that case put the code I gave you in the Sheet2 Activate event and then follow it with the name of your macro.

Regards

**rizmomin** · 02-21-2012, 11:59 AM

Hi Richard:

Sorry but i did not understand "Acticate Event"

Please refer to attached excel sheet...the macro is in CLOCKIN-OUT.

Thanks

RM

**Richard Buttrey** · 02-21-2012, 01:24 PM

Hi,

I meant you to put the macro in the Sheet2 Activate event. i.e. the event that is triggered whenever you move to sheet 2.

You originally mentioned sheet 2 but there is no sheet named 'Sheet2' either as a tab name or as a VBA code name. I'm assuming therefore that you mean the second tab name called 'Calc'

I've put the macro in the SheetChange event of the Calc sheet therefore.

Regards

**rizmomin** · 02-21-2012, 01:35 PM

Hi Richard:

Thanks, this will work for me..
Hey, what code would i need to add so that the Paste part in Sub Ert() would be sorted Ascending.

Appreciate your help.

RM