automatically using VBA code in Sheet 1

's Computer Specifications

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

's Computer Specifications

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.ah...@gmail.com wrote:
> 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

's Computer Specifications

On May 8, 2:21 pm, JWRIGH...@triad.rr.com wrote:
> 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.ah...@gmail.com wrote:
> > 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

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

's Computer Specifications

Sure.

adeel.ah...@gmail.com wrote:
> On May 8, 2:21 pm, JWRIGH...@triad.rr.com wrote:
> > 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.ah...@gmail.com wrote:
> > > 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
>
> 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

's Computer Specifications

On May 8, 2:35 pm, JW <JWRIGH...@triad.rr.com> wrote:
> Sure.
>
> adeel.ah...@gmail.com wrote:
> > On May 8, 2:21 pm, JWRIGH...@triad.rr.com wrote:
> > > 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.ah...@gmail.com wrote:
> > > > 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
>
> > 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

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

's Computer Specifications

Just sent it back to you.

(E-Mail Removed) wrote:
> On May 8, 2:35 pm, JW <JWRIGH...@triad.rr.com> wrote:
> > Sure.
> >
> > adeel.ah...@gmail.com wrote:
> > > On May 8, 2:21 pm, JWRIGH...@triad.rr.com wrote:
> > > > 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.ah...@gmail.com wrote:
> > > > > 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
> >
> > > 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
>
> i sent it to your email triad.rr.. thanks

's Computer Specifications

On May 8, 3:00 pm, JW <JWRIGH...@triad.rr.com> wrote:
> Just sent it back to you.
>
> adeel.ah...@gmail.com wrote:
> > On May 8, 2:35 pm, JW <JWRIGH...@triad.rr.com> wrote:
> > > Sure.
>
> > > adeel.ah...@gmail.com wrote:
> > > > On May 8, 2:21 pm, JWRIGH...@triad.rr.com wrote:
> > > > > 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.ah...@gmail.com wrote:
> > > > > > 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
>
> > > > 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
>
> > i sent it to your email triad.rr.. thanks

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

aaa

's Computer Specifications

Right back at ya.

(E-Mail Removed) wrote:
> On May 8, 3:00 pm, JW <JWRIGH...@triad.rr.com> wrote:
> > Just sent it back to you.
> >
> > adeel.ah...@gmail.com wrote:
> > > On May 8, 2:35 pm, JW <JWRIGH...@triad.rr.com> wrote:
> > > > Sure.
> >
> > > > adeel.ah...@gmail.com wrote:
> > > > > On May 8, 2:21 pm, JWRIGH...@triad.rr.com wrote:
> > > > > > 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.ah...@gmail.com wrote:
> > > > > > > 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
> >
> > > > > 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
> >
> > > i sent it to your email triad.rr.. thanks
>
> Thanks its workin but needs slight adjustment. Please check your
> email.
>
> aaa

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: automatically copying data from one sheet to another, depending on which drop-down code is allocated	Max	Microsoft Excel Discussion	7	4th Feb 2009 04:47 PM
create a formula in one sheet that would read data from separate sheet automatically	QD	Microsoft Excel Misc	0	8th Dec 2006 04:17 AM
how to prevent a formula in a summary sheet from automatically updating when a row is addedto the referenced sheet	krisp1950@gmail.com	Microsoft Excel Discussion	2	13th Jan 2006 02:33 AM
Automatically entering sheet names into a range of cells on one sheet	u539771	Microsoft Excel Worksheet Functions	2	23rd Jun 2004 12:54 PM
Why wouldn't calling the Activate sub for a sheet automatically call that sheet's Worksheet_Activate() sub?	Scott Lyon	Microsoft Excel Programming	3	19th Aug 2003 03:03 PM