I want to appoint a shortcut for common button. Is it possible ?
Second thing is that I wrote the code from common button. However, when I scroll down on the page, common button does not go down. Can I motion it with page?
I want to appoint a shortcut for common button. Is it possible ?
Second thing is that I wrote the code from common button. However, when I scroll down on the page, common button does not go down. Can I motion it with page?
Where do you want the shortcut for the button to be? If on an excel spreadsheet, you could freeze the cells, rows that the button is in and it will stay in place as you scroll.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
I don't know enough about VBA to add a shortcut/button to the toolbar. To freeze where the button is, Select the View tab, select the last row below the button on the spreadsheet, then select Freeze Panes and Freeze Panes again. The problem with this is that it freezes all the rows above the row you selected.
Ok, I' ll try.
Thank you =)
You're welcome, hope this solves at least part of your issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks