Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 Tags
Subject: RE: Minimize Ribbon in Excel 2007?
Thread ID: 269081 Message ID: 269099 # Views: 31 # Ratings: 0
Version: Visual FoxPro 9 Category: Active X Controls & OLE Automation
Date: Friday, July 16, 2010 11:47:50 AM         
   


> > Does anyone know how to programmatically minimize ribbon in excel 2007 inside VFP? And if we can, how to show it back again. Thanks!
> >
> >
> >
> > http://www.junblogs.com/
> > http://weblogs.foxite.com/sandstorm36/default.aspx
> > http://www.coderisland.com/forum/viewforum.php?f=10
>
>
> try this
>
> 
> Local x as Excel.Application
> x=CREATEOBJECT("excel.application")
> x.Visible =.T.
> 
> 
> 
> x.ActiveWindow
> 
> x.Application.SendKeys ("^{F1}")
> 
> 

>
> Anil
>
> My Blog


Fantastic! Thanks Anil.

One more thing though, that will "toggle" visibility of ribbon. Is there any way we can check its status first so I can deactivate it conditionally?



http://www.junblogs.com/
http://weblogs.foxite.com/sandstorm36/default.aspx
http://www.coderisland.com/forum/viewforum.php?f=10

ENTIRE THREAD

Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 10:52:12 AM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 11:39:13 AM
RE: Minimize Ribbon in Excel 2007? Posted by Mike Gagnon @ 7/16/2010 11:47:48 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:47:50 AM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 11:56:50 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:01:09 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 12:05:08 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:08:42 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:19:58 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 1:08:21 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 1:40:12 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 2:08:53 PM
RE: Minimize Ribbon in Excel 2007? Posted by Mike Gagnon @ 7/16/2010 11:44:01 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:51:08 AM
RE: Minimize Ribbon in Excel 2007? Posted by Borislav Borissov @ 7/16/2010 11:44:15 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:53:41 AM
RE: Minimize Ribbon in Excel 2007? Posted by Yousfi Benameur @ 7/16/2010 12:53:16 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 1:43:55 PM