Easiest thing is to change the existing code from enabling/disabling to
hiding/unhiding.

You could add buttons to a worksheet, there are two types - forms toolbar
buttons and control toolbox buttons to choose from.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Candee" wrote in
message ...

Thanks for your responses dominicb and Bob.

If I were to hide it using the visible property, would the
worksheet-beforeclose be the correct place to unhide it so that when
the file is opened the next time, it would be there? Or should I just
change the vb to be that if the username is an owner that button
appears or user just that button shows?

Can this coding be done so that I don't even need to have the userform
at all? Just check the name when the workbook opens and show/hide
sheets based on that?

I appreciate all your help and comments,
Candee


--
Candee
------------------------------------------------------------------------
Candee's Profile:
http://www.excelforum.com/member.php...nfo&userid=638
View this thread: http://www.excelforum.com/showthread...hreadid=483581