automatically using VBA code in Sheet 1

[adeel.ahmad]

I have written the code in sheet one but when i open excel nothing
happens. Excel should ask the user if he wants to start the program
but it doesnt do anything. But if the toggle through manually through
the code in Sheet1 it works perfectly.

What do i need to do so that it starts automatically when ever i open
excel.

Your help would be greatly appreciated.

AAA

 

[JWRIGHT50]

Move the code into the ThisWorkbook module and place it in the
Workbook_Open event. Or, you could rename the macro Auto_Open and it
should fire when the workbook is opened.

Hope this helps.

 

[adeel.ahmad]

Move the code into the ThisWorkbook module and place it in the
Workbook_Open event. Or, you could rename the macro Auto_Open and it
should fire when the workbook is opened.

Hope this helps.

its still not working.. is it possible for me to send u the file. im
sure itll take u a min to figure out
thanks,

aaa

 

[JW]

Sure.

its still not working.. is it possible for me to send u the file. im
sure itll take u a min to figure out
thanks,

aaa

 

[adeel.ahmad]

Sure.

i sent it to your email triad.rr.. thanks

 

[JW]

Just sent it back to you.

i sent it to your email triad.rr.. thanks

 

[adeel.ahmad]

Just sent it back to you.

Thanks its workin but needs slight adjustment. Please check your
email.

aaa

 

[JW]

Right back at ya.

Thanks its workin but needs slight adjustment. Please check your
email.

aaa