+ Reply to Thread
Results 1 to 3 of 3

Application.sendkeys - strange result! - Excel 2010

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    87

    Application.sendkeys - strange result! - Excel 2010

    hi

    i have the following code which is supposed to minimize the ribbon when the workbook is opened

    Please Login or Register  to view this content.
    this works on one workbook but not another! on the second workbook, the code opens excel help, which you
    can get by just pressing F1, but the code is for "Ctrl + F1". What could be the issue here?

    cheers


    i even tried Application.CommandBars.Item("Ribbon").Height but same result

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Application.sendkeys - strange result! - Excel 2010

    What happens if you manually press Ctrl+F1 in the second workbook?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    04-19-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: Application.sendkeys - strange result! - Excel 2010

    hi
    manually pressing works as expected, hiding or unhiding the ribbon.
    cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Application.Sendkeys for Mac Excel
    By nalgene5622 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 09:42 PM
  2. Application.sendkeys help
    By viruzman in forum Excel General
    Replies: 1
    Last Post: 03-26-2008, 10:13 PM
  3. [SOLVED] Close an application with sendkeys
    By ina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2006, 03:20 AM
  4. The application SendKeys
    By Jim333 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 12:44 AM
  5. SendKeys and Application.ScreenUpdating
    By Michael Malinsky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1