Re: $$Excel-Macros$$ how to call proc on sheet refering sheetname

2013-03-11 Thread Santosh V
Thanks David...its working On Mon, Mar 11, 2013 at 6:34 PM, David Grugeon wrote: > This works > > Application.OnTime Now() + TimeValue("00:00:05"), Sheets("Test").CodeName > & ".CommandButton1_Click" > > Regards > David Grugeon > > > > On 11 March 2013 21:52, Santosh V wrote: > >> Waiting for r

Re: $$Excel-Macros$$ how to call proc on sheet refering sheetname

2013-03-11 Thread David Grugeon
This works Application.OnTime Now() + TimeValue("00:00:05"), Sheets("Test").CodeName & ".CommandButton1_Click" Regards David Grugeon On 11 March 2013 21:52, Santosh V wrote: > Waiting for reply.. > > > On Mon, Mar 11, 2013 at 2:07 PM, Santosh V wrote: > >> Please find the sample file att

Re: $$Excel-Macros$$ how to call proc on sheet refering sheetname

2013-03-11 Thread Santosh V
Waiting for reply.. On Mon, Mar 11, 2013 at 2:07 PM, Santosh V wrote: > Please find the sample file attached. > > > On Mon, Mar 11, 2013 at 1:41 PM, Abhishek Jain wrote: > >> A sample workbook would be helpful to understand better. >> >> >> On Mon, Mar 11, 2013 at 12:32 PM, Santosh V wrote:

Re: $$Excel-Macros$$ how to call proc on sheet refering sheetname

2013-03-11 Thread David Grugeon
I would try Application.OnTime Now() + TimeValue("00:00:05"), "Sheets(""Test""). CommandButton1_Click" First I think you need the . instead of the ! which you use in worksheet functions. Next, you need a string in double quotes. Then where you want the name of the file in the brackets you doubl

Re: $$Excel-Macros$$ how to call proc on sheet refering sheetname

2013-03-11 Thread Abhishek Jain
A sample workbook would be helpful to understand better. On Mon, Mar 11, 2013 at 12:32 PM, Santosh V wrote: > Any one ??? > > > On Mon, Mar 11, 2013 at 12:22 AM, Santosh V wrote: > >> Be, >> >> Its not what i am looking for. Thanks for your respone. >> >> >> >> On Mon, Mar 11, 2013 at 12:14 AM,

Re: $$Excel-Macros$$ how to call proc on sheet refering sheetname

2013-03-11 Thread Santosh V
Any one ??? On Mon, Mar 11, 2013 at 12:22 AM, Santosh V wrote: > Be, > > Its not what i am looking for. Thanks for your respone. > > > > On Mon, Mar 11, 2013 at 12:14 AM, Bé Trần Văn > wrote: > >> Use CommandButton1_Click to select sheet >> Code: >> >> Private Sub CommandButton1_Click() >> Shee

Re: $$Excel-Macros$$ how to call proc on sheet refering sheetname

2013-03-10 Thread Santosh V
Be, Its not what i am looking for. Thanks for your respone. On Mon, Mar 11, 2013 at 12:14 AM, Bé Trần Văn wrote: > Use CommandButton1_Click to select sheet > Code: > > Private Sub CommandButton1_Click() > Sheets("TTLongThanh").Select > End Sub > See Attachment > 2013/3/11 Santosh V > >> Privat