http://www.j-walk.com/ss/excel/tips/tip49.htm

--
Regards,
Tom Ogilvy


"brownti via OfficeKB.com" wrote:

I like that idea. That way i could incorporate selecting the tab color, and
name into the userform also so it is only one button click to do everything.
Is there an "easy" way of putting the color pallette in a userform, or does
someone have code to do it?

Tom Ogilvy wrote:
You could protect the structure of the workbook so a sheet could not be
copied and force the user to use a menu or button.

Is there an action for beforesheetcopy? I want to run a userform prior to
copying a sheet. Is that possible?

--
Message posted via http://www.officekb.com