Greetings,
I am having issues using the Application.SendKey F1. I have entered the following code and then close the workbook. When I open the workbook, the command area of the ribbon is hidden - all good. But when I close the workbook and open another workbook, the command area is still hidden. And when I open the original workbook (with the following code), the command area is shown.
Please Login or Register to view this content.
Hello brentjohn,
You really shouldn't rely on SendKeys for this. The Ribbon hide/show command toggles the Ribbon depending on it's state. If it is showing then it is minimized. If it is minimized then it is hidden.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Leith,
Thank you much for your response.
I replaced my code with your and when I tried closing the workbook I received a Run-time error '91': Object variable or With block variable not set.
Hello brentjohn,
I forgot when using the Workbook Open event that you must use fully qualified constructs. Replace your code with the code below. It should take care of the problem.
Please Login or Register to view this content.
Leith,
That works great!
Thank you much!
Hello brentjohn,
You're welcome. As many times as I have forgotten to do this in my own projects, I should have gotten it right the first time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks