| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When a sheet is copied, i want also that the Sub's whithin this sheet is copied to the new sheet
Title says it all !
Thanks, Luc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When a sheet is copied, i want also that the Sub's whithin thissheet is copied to the new sheet
Hi Luc
When ever you move a sheet the code within that worksheet module will move also. If however you are talking about the module level code that just happens to be used on the sheet then no it will not go with the sheet. If the latter is what you ment you could put the code specific to that sheet within the Sheet Module and this will move when ever you move your sheet. Take care Marcus |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When a sheet is copied, i want also that the Sub's whithin this sheet is copied to the new sheet
Thanxxxxxx, i know what i did wrong :=)
"marcus" schreef in bericht ... Hi Luc When ever you move a sheet the code within that worksheet module will move also. If however you are talking about the module level code that just happens to be used on the sheet then no it will not go with the sheet. If the latter is what you ment you could put the code specific to that sheet within the Sheet Module and this will move when ever you move your sheet. Take care Marcus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copied from web page to excel sheet and cant remove from sheet | Excel Worksheet Functions | |||
| copied from web page to excel sheet and cant remove from sheet | Excel Worksheet Functions | |||
| copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
| rename a copied sheet | Excel Programming | |||
| Sheet module VBA not copied | Excel Programming | |||
![Luc[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
