Shortcut buttons for printing/scrolling on a worksheet
Shane,
Thank you for your post. It's good to know that there is a way to create
the buttons or use hyperlinks. I'm not that familiar with doing either. The
code transfered over with the file but I can't get it to work using either
the Controls of Format toolbars in my 2003 Excel. Any suggestions on where
to go from here (it's for another company and they're quite dependant on the
buttons!!)?
--
Thanks for all your help!
"ShaneDevenshire" wrote:
Hi,
I don't have Quattro, however, buttons can be create on the spreadsheet in
Excel using either the Forms toolbar or the Controls toolbar (2003 or
earlier). There are button tools on both. You will probably need to write
code, I don't know if any code came across when you imported the files.
If VBA (code) is new I suspect you won't want to learn it just to do these
tasks. For moving around you might try inserting Hyperlinks. For printing
you might try recording the process.
--
Cheers,
Shane Devenshire
"Mudd" wrote:
I'm transfering a file from Corel QuattroPro to Excel. The file contained
"shortcut" buttons on each page for printing a specified section or scrolling
down to another portion of the page. I'm wondering if there's a way to
create these buttons in Excel.
--
Thanks for all your help!
|