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: 269117 # Views: 26 # Ratings: 0
Version: Visual FoxPro 9 Category: Active X Controls & OLE Automation
Date: Friday, July 16, 2010 12:19:58 PM         
   


> >
> >
> > 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
>
> yes but tricky
>
> if x.Application.CommandBars.Item("Ribbon").Height > 100 Then
>
> x.ActiveWindow
>
> x.Application.SendKeys ("^{F1}")
> endif
>
>
> Anil
>
> My Blog


Err.. Anil, I closed the excel with ribbon minimized so I thought it is no longer toggling. But that actually seems to not work as expected. Sorry.



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