Pete
07-24-2008, 07:50 AM
Hi
Driving me mad.....but cannot see the answer.
Here is the problem: - Need the macro to do the following two steps ONLY.
1. If you clicks worksheet "Administrator" then a userform appears which they can press cancel to go back to wworksheet "Daily Cmmunicatons Log" - if they press ok then nothing happens would like a msg box "Please Enter A Vaild Password"
2. If then the user clicks the worksheet "Daily communications log" whlist in the worksheet "Administrator" they are unbale to switch worksheet without pressing the cancel button on the userform......what to be able to switch irrespective of if i press cancel on the userform or the other worksheet Tab...
just that
Driving me mad.....but cannot see the answer.
Here is the problem: - Need the macro to do the following two steps ONLY.
1. If you clicks worksheet "Administrator" then a userform appears which they can press cancel to go back to wworksheet "Daily Cmmunicatons Log" - if they press ok then nothing happens would like a msg box "Please Enter A Vaild Password"
2. If then the user clicks the worksheet "Daily communications log" whlist in the worksheet "Administrator" they are unbale to switch worksheet without pressing the cancel button on the userform......what to be able to switch irrespective of if i press cancel on the userform or the other worksheet Tab...
just that