Hi Paul, Thanks for the answer I checked the same idea before I sent the message, I give the fullscreen code when the work book open, but when I give the code for display screen normal when work book deactive it is not working as we think.that's why I posted it.Will u pls send attached sheet with the macro u mentioned.If so I can understand what is the fault I made. Regards
Rajesh kainikkara On 4/21/11, Paul Schreiner <schreiner_p...@att.net> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
