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

no, there is no beforesheetcopy event.

The newsheet event doesn't seem to fire on a copy and would be after anyway
if it worked. I don't think you would be able to trap it before it happens.

--
Regards,
Tom Ogilvy


"brownti via OfficeKB.com" wrote:

> 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
>
>

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.

--
Regards,
Tom Ogilvy


"brownti via OfficeKB.com" wrote:

> 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
>
>

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

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
>
>