John,

I aimed at the same result by different route. One the user accept
the Eula, another "registration" user form comes up. This form gather
some information and pastes the user's name into cell A1 of the Eula.

In a different part of the spreadhseet there is a cell that asks th
user to enter their name. If the user uses registration, then thi
cell (lets call it Sheet1.target("B1"), herein after "Workbook Name"
is already filled in for them via the userform.

If a person changes the Workbook Name then I am trying to launch
macro that hides all the sheets, and shows the Eula userform again....

I having problems coding this, however. I just posted another thrrea
tying to solve this problem, namely that I am having difficulty tryin
to lauch the macro when Sheet1.target("B1") does not matc
Eula.Target("A1")

--
Message posted from http://www.ExcelForum.com