Solved: VBA code for a button with user supplied titles

[Bob Blooms]

I would like to add a button to the active worksheet if a range in an inactive worksheet is > "". The label of the button would be the name of the inactive worksheet. On click the user would be sent to the range.

From a higher perspective what I am trying to create is a graphic of goals that are spelled out on individual worksheets. The detail on each worksheets would be the objective to be met for each goal. I think what I'm trying to accomplish is an interactive Visio sheet in an Excel workbook. The ultimate goal is to be able to drill down to specific budget item. Or to roll up into a budget document.

[mdmackillop]

Add the buttons and set Visible property to false. You could then use Event code to make the button visible.