Data Validation "Input Message"

[BrWolv]

Hi,
I am trying to add an Input Message to Cell A1 of all Worksheets within my Book. I have recorded a Macro & added a shortcut to run it manually, however, I am hoping someone could provide the code to run on all Sheets. The Input Message will state "Press Property Name To Return To Master".

I am using the Data Validation Tab to enter the input message, not sure if there is a better way.

thanks

 

[Nalani]

Not completly sure of what you want to do.

If you type your statement in A1, hit Enter

Then go back to A1 > Right Click and choose Hyperlink
In the box that appears: Choose, in the Link to: Place in This Document
Then in the large area to the right, Click on Master (if you have a sheet named Master)

Copy A1 to all other sheets.

 

[BrWolv]

I have a Hyperlink set up on a "Mastershee" which links to each respective worksheet. When the link is clicked on the master, it opens the other sheet up & CellA1 is the reference cell. I would like to have the input message displayed when the user opens the sheet, so that they are aware that they can use the hyperlink to return to the master worksheet.
I installed ScreenTips, however, that requires a User to Hover over the cell before it pops up, which will almost ever happen. If i add the Input Message to Cell A1, then everytime a user links to that page, it will automatically tell them they can link back to Master. My intent is to add a few Input messages to assist the multiple users & help with overall navigation