Where is the transpose button in excel3/15/2023 ![]() You need to be sure you though that you include the reformatting of each of the other buttons back to the drab color you started with so they'll appear to be turned off when you're on another button. I like to use "From center" on the Gradiants tab in the Fill Effects so it looks like the active botton is being lit in the center. ![]() I'll then have the macros reformat the colors as I click on each one so that the one I last clicked on will be different from all the rest. With a half dozen of them all lined up side by side, I'll usually format them with some drab color. I like to use the auto-shape that looks like a rectangular button a lot and add a little shadow to it for depth. I found that recording a color change into each macro when I click on it spares me any confusion. On a somewhat related topic: If I have several macro buttons set up across the screen, I can sometimes get distracted and forget which macro I last clicked. I don't know about changing on hover either but that would be cool. Just frame the current button with your cursor and choose a different shape. If you select "Draw" from the Drawing toolbar on the View menu you'll see there is an option to Change Auto Shape (I think it's down at the bottom left-hand corner of the screen). ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |