I'm certain this is not the only "fix" for this problem, nor is it likely the most efficient, elegant or effective method, but it works. This form uses the macro above to run steps 1-3 automatically between the time the user prints and returns to the workbook. You'll notice that the command buttons are visible on all worksheets. Second, open "HCT-RCS ITP V1.84", select the Print Entire Workbook option, and without hitting the print button return to Sheet "Demographics". Click "Show Toolbar" and the ribbon will reappear.**** ****The following form runs macros upon open that among other things hides the ribbon. For the fun of it, follow steps 1-3, as outlined above, and the buttons should re-appear. On the final Sheets in the workbook you'll notice that the command buttons are gone altogether. You'll notice that on Sheet "Demographics" the command buttons are still present while on Sheet "Presenting Problems & Progress" the buttons are there but barely visible. This will ONLY work if you are using Excel 2010, as the problem with the disappearing buttons only exists within Excel 2010.įirst, open "HCT-RCS ITP Button Test", select the Print Entire Workbook option, and without hitting the print button return to Sheet "Demographics". Select the box labeled Show Quick Analysis Options on Selection. Tick Mark shows you if Quick Analysis is activated. Click on the File tab, then Options, and select Tick Mark. I've attached two workbooks to this thread to illustrate the problem and the "fix". Here’s an easy fix to turn the Quick Analysis tool on, with a few simple steps. Please Login or Register to view this content. Once the Command Buttons disappear from a worksheet complete the following steps:Ĥ) Return to your workbook and the buttons should be present and accounted forįor the purpose of my project I found and modified two pieces of code (Kenneth & Trevor ) and jaslake supplied a third piece of code to run the above 3 steps "behind the scenes" after a user selects "Print Entire Workbook". Through a ton of trial and error and help with coding provided by jaslake, a workable "fix" was found for the disappearing buttons. A fellow forum member (jaslake), who has been helping me with my project, found that the offending feature that is at the center of the disappearing buttons is the "Print Entire Workbook" (click link below for jaslake's post on the matter): While building a form for work, using Excel 2010, I ran across a glitch in Excel 2010 that causes Command Buttons in a workbook to disappear.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |