Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Move buttons with Scrolling?
- Thread starter bjd4jc
- Start date
it's possible but tricky. an easier solution is to put them all at the top and freeze the panes just after them - that way, they remain visible whilst scrolling (along with any headers etc)
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Thread starter
- #3
I'm talking really tricky - creating a class module to handle scrollbar movement events......still interested ??
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Thread starter
- #5
ok - I've looked into this and I'm really not sure that this is even possible. You can create events for application objects but the scrollbar is not one of them. The only event that refers to a scrollbar is that on a multiline textbox for example - which is not what you want. I would suggest that you may be better off creating a floating, custom toolbar - you can have macros attached to the buttons and it would always be visible.
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Thread starter
- #7
xlbo-
Thanks for looking into that. I didn't mean for you to have to do all of that. I thought that you already had a solution created and that you would just paste it here. I was under the impression that you already had it done. This really isn't that big of a deal,,, yet. I was just trying to be proactive and maybe solve the problem before the users saw it as such. If it comes down to it, I'll let them make the decision on what to do. Thanks for the ideas.
Brian
Thanks for looking into that. I didn't mean for you to have to do all of that. I thought that you already had a solution created and that you would just paste it here. I was under the impression that you already had it done. This really isn't that big of a deal,,, yet. I was just trying to be proactive and maybe solve the problem before the users saw it as such. If it comes down to it, I'll let them make the decision on what to do. Thanks for the ideas.
Brian
Yeh - sorry if I gave that impression - I was working under the assumption that I had seen something similar discussed on one of my excel distribution lists......but having searched their archives, I can only come to the conclusion that I was having halucinations <g>
I thought it would be possible as I had seen a scrollbar event mentioned but when I looked into it, it was only for the multipage textbox scrollbars - not the worksheet ones.
If it does become a problem, I;d suggest that a custom toolbar that loads up with the workbook_open event and deletes itself with the close event should work well
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
I thought it would be possible as I had seen a scrollbar event mentioned but when I looked into it, it was only for the multipage textbox scrollbars - not the worksheet ones.
If it does become a problem, I;d suggest that a custom toolbar that loads up with the workbook_open event and deletes itself with the close event should work well
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Geoff: I thought I remembered a solution posted here too (and couldn't find it), but maybe it is just one I was trying to come up with. By processing the SelectionChange event it is possible to re-position buttons (loop thru controls collection, processing the ones you want to re-position). The thing is, scrolling alone doesn't do it. The buttons re-appear only after the user clicks in a visible cell. Rather unsatisfying. Much prefer your idea of putting them above the freeze line or in a toolbar. Could also put them in a modeless form if using 2K or later. (Not in '97 however.)
- Status