Is ther any way to create a button that always stays on the screen.
i.e. it is not locked on to a specific cell and will remain in view even if i scroll way down the screen.
Right now i have multiple buttons that do the same thing all over my sheet for speed but one that always stayed in view would be much better.
Thanks
If you are using pre-2007, you could create a custom toolbar and put your buttons on that. (There's probably a way in 2007 that I'm unaware of.)
The tricky part is that the custom toolbar is part of the Application and not the workbook containing your macros. I use Workbook_Activate and _Deactivate routines to show/hide the toolbar when appropriate.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Another option would be to place all the buttons and the top of the sheet and then freeze the first row or two.
I guess excel is not magic.
Thanks for the ideas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks