Re: $$Excel-Macros$$ Custom view change automatically after time set

2016-01-14 Thread Abhishek Jain
Change the code to this: Private Sub Workbook_Open() ActiveWorkbook.CustomViews("TODAY'S BIRTHDAY").Show Application.Wait (Now + TimeValue("00:00:10")) ActiveWorkbook.CustomViews("ALL PERSONS").Show End Sub Change the highlighted time delay as per your need. On Fri, Jan 15, 2016 at 8:52 AM, b

$$Excel-Macros$$ Custom view change automatically after time set

2016-01-14 Thread big smile
Yes thanks a lot it works nicely Now i can do the same thing in other files too I really appreciate & thanks to have a such group. I am learning excel in details so i may have lot of queries too Even i have ask is there any course available in Mumbai then please let me know . I always think cr