Hi Guys

I am trying to find a way to update a hidden sheet, but display what is put there on a visible sheet which is protected, in a shared workbook (erugh!). My thought is to reference the hidden sheet on the visible one (=Sheet1!A1). Is there any VBA code that would allow user input from a msgBox to follow the address given in selected cell on the visible sheet and update the hidden one.

I'm guessing this will either be really easy, or impossible but any help will be appreciated

Many Thanks in advance

MrSaunders