You really need to create two event macros. the workbook_activate event would go to full screen when you "select" the workbook, if you use a workbook_deactivate macro to change the displayfullscreen to "false", it will revert to "normal" for when in any other workbook or window.
Paul ________________________________ From: ChilExcel <chilexcel...@gmail.com> To: excel-macros@googlegroups.com Sent: Wed, April 20, 2011 12:43:36 PM Subject: Re: $$Excel-Macros$$ Show full screen for a particular workbook only. You need add ins ? 2011/4/20 rajan verma <rajanverma1...@gmail.com> make it add-ins > > > >On Fri, Apr 15, 2011 at 5:16 PM, Rajesh K R <rajeshkainikk...@gmail.com> wrote: > >Hi Experts, >> >>I gave the following code to get the full screen view, if it is only >>applicable to that particular workbook how can i change it. >> >> >>Private Sub Workbook_Open() >>Application.DisplayFullScreen = True >>End Sub >> >>Regards >>Rajesh kainikkara >> >>-- >>---------------------------------------------------------------------------------- >> >>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 >> >><><><><><><><><><><><><><><><><><><><><><><> >>Like our page on facebook , Just follow below link >>http://www.facebook.com/discussexcel >> > > >-- >Regards >Rajan verma >+91 9158998701 > >-- >---------------------------------------------------------------------------------- > >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 > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel