Clearing user inputs.....

Hmmm...no macros, right?

OK...for the inputs:
Holding down the Control key, use the mouse to click on each Input Cell.
Once you have them all, release the Control key.
Then Insert>Names>Define and create a descriptive named range(s), like UserInputs.

Then, whenever you want to reset values:
Edit>Go To> UserInputs......Then press the Delete key to erase the contents OR Enter a Zero, then hold down the Control Key and press Enter to put zeroes in the selected cells.

To change the definition of InputCells, use Edit>Go To> UserInputs, the hold down the Control Key while you select additional cells. Then just redefine the range name

Regarding workbook navigation, you can set up hyperlinks on the sheets that refer to other sheets in the same workbook.

Does any of that work for you?

Regards,
Ron

For the second part of your post, you can put in a Hyperlink to go to another page or part of a worksheet. Use Insert - Hyperlink - Bookmark to create. If you want it to go to a certain cell (instead of a certain worksheet) you will want to give that cell a range name.

Originally Posted by stvgarner

For the second part of your post, you can put in a Hyperlink to go to another page or part of a worksheet. Use Insert - Hyperlink - Bookmark to create. If you want it to go to a certain cell (instead of a certain worksheet) you will want to give that cell a range name.

This works a treat! - One Issue!

Can this approach be used to hyperlink to a full sheet chart?

I cannot find the chart under the hyperlink dialog where I acan link to the report..

Thanks

Tom