 |
|
|
|
|
|
Current Special! Complete Excel
Excel
Training Course
for Excel 97 - Excel 2003, only $145.00.
$59.95 Instant
Buy/Download,
30 Day Money Back Guarantee & Free
Excel Help for LIFE!
Got any Excel Questions? Free Excel Help
Workbook/Sheet Hyperlinking & alternatives
Mkalsem had a main workbook and 3 “sub” workbooks. He wanted to be able
to click in a cell and have that command take him to a specific page in a
different workbook. He was having trouble getting the hyperlinks to work.
Chris Davison suggested taking a picture of the destination location via
the camera utility then paste this into your main workbook.
When you double click the image, it will hyperlink you to the source
To set up the Camera utility, try the following:
View
Toolbars
Customise
Commands
Tools..........
Scroll down the tools options and click the
Camera icon and drag it to
your toolbar, you should now have a camera sitting on your toolbar.
To use it, highlight your cells in question and click the
Camera, this
will take a snapshot of those cells (Dave Hawley pointed out that you can also
get a 'picture' of your cells by selecting them, hold down the Shift key
and going to Edit>Copy Picture) - now go to where you want
to show them as an image, paste and resize the image to suit.
NB - If your source cells change, the image will also change, similar to a
linked cell.
royUK explained that you can set up hyperlinks to a sheet or named range
in a workbook or another workbook by using the Insert>Hyperlink
method.
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS