| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before sheet copy
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Before sheet copy
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Before sheet copy
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Before sheet copy
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Before sheet copy
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| providing a sheet-copy event or copy CustomProperties | Excel Programming | |||
Linear Mode
