Good evening Candee
AFAIK there is no check within VBA once a button is disabled, so yo
cannot check if it has been clicked. You could set up a label t
display a message such as this if a user logs on. Alternatively, yo
could just hide the button altogether if the user is a user (if you se
what I mean):
bOwner.Visible=False
So the user only sees what they are authorised to.
HTH
Dominic
--
dominic
-----------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...fo&userid=1893
View this thread:
http://www.excelforum.com/showthread.php?threadid=48358