Try this, But check it may have adverse effects,
Private Sub CommandButton2_Click() UserForm1.Show 0 End Sub Also check for help on SHOW method ( modal/nonmodal forms). Share with me if you have any problems Bye, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Aug 5, 6:38 am, Intelligent But Crazy <secrets...@gmail.com> wrote: > Hi Dav, > > First of all congrats, I request you to pls help me in > this problem, my whok project n promotion is now only depands on this. > > I m waitinig for your reply. > > Regards > Pankaj k Pandey > > On 8/4/10, Intelligent But Crazy <secrets...@gmail.com> wrote: > > > > > My Apologiese > > > Pls find the Password details. > > > For Workbook : bads...@143 > > For VBA Editor : bads...@143 > > For Worksheets : SecretShot > > For Mastersheet : SecretShot > > > Pls help me in this. > > > Thanks > > Pankaj k Pandey > > > On 8/3/10, Intelligent But Crazy <secrets...@gmail.com> wrote: > >> Hi group, > > >> My self pankaj, > >> currentally I m working on a project, I have created a Excel VBA form > >> for quality analysis, but i m facing a problem that when the VBA form > >> is open in this Excel so i m unable to activate any onather Excel > >> file. > >> Pls help me in this only because of this my whole project will be > >> useless. > > >> Excel file is attech for refarence. > > >> Thanks > >> Pankaj k Pandey > > >> -- > >> ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >>http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >> To post to this group, send email to excel-macros@googlegroups.com > > >> <><><><><><><><><><><><><><><><><><><><><><> > >> HELP US GROW !! > > >> We reach over 7000 subscribers worldwide and receive many nice notes > >> about > >> the learning and support from the group.Let friends and co-workers know > >> they > >> can subscribe to group at > >>http://groups.google.com/group/excel-macros/subscribe > > > -- > > Pankaj Pandey > > Bhopal > > -- > Pankaj Pandey > Bhopal -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
