check the attachment see if it helps On Sun, Apr 24, 2011 at 8:33 PM, Rajesh K R <rajeshkainikk...@gmail.com>wrote:
> 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 > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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
full screen.xlsm
Description: Binary data