I have 1 workbook with two sheets.

In Sheet 2the operator can make entries:,

A . . . In a specified cell (example A1), I want the user to enter a workbook name such as Checkbook.xls. In cell B1, the operator would enter a short text name like Checkbook.

B . . . In cell A2, I want the user to enter a URL such as www.ebay.com They could then edit the text to eBay if need be. In Cell B2, the user would enter a short name like eBay.

Now to Sheet 1, this sheet is protected and the user can not make any entries or changes:

Re: A
I want a macro in any cell (my choice) that will display the Text as entered into sheet 2 either from cell A1 or B1, whatever will help the macro easier to program. When the macro is clicked, the macro will open the file shown in Cell A1 . . . Sheet2.


Re: B
I want a macro in any cell (my choice) that will display the Text from Cell A2 or B2 whichever will help the macro easier to program . . . from Sheet2.

When this macro is clicked, I want the URL they entered in Cell A2 . . . Sheet2, to open.

A & B Macros could be either a button "Artwork" or simply a link. I prefer the links.


WOW . . . I hope that somebody can understand what I am explaining.