floating buttons..
Posted by nisha on December 20, 2001 11:54 AM
I have recorded a macro which chooses a cell and pastes it on another sheet. I have assigned this macro to a button which i placed on the sheet. Since i have a lot of data i have to move around the sheet i lose the button and have to press cntrl+letter to invoke the macro. Is there a way where the button "floats" regardless where I have moved on the sheet?
Posted by Tom on December 20, 2001 12:01 PM
How about a custom macro button on your toolbar?
Posted by nisha on December 20, 2001 12:30 PM
tried that but no good
Did that but it's too small up there, I need a rather medium size block or blob which just "floats".
Posted by Juan Pablo G. on December 20, 2001 12:37 PM
Re: tried that but no good
Buttons don't "float", that's why there are toolbars.
Juan Pablo G.
Posted by Chris D on December 20, 2001 1:19 PM
You could sacrifice a column and/or some rows with freeze pane and put your large button within the frozen panes, alas this reduces your visible area somewhat....
Posted by Tom Dickinson on December 20, 2001 4:17 PM
Re: tried that but no good
Of course, you could create several buttons around the project, all of which start the same macor; or you could just create a keystroke shortcut (go to the list of macros, highlight the one you want, select "Options", and enter the shortcut; I normally start with a capital Z).
Posted by nisha on December 20, 2001 11:24 PM
Excellent idea Tom...Thanks a million (nt)
