| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 Copy Sheet ?'s
Curious. Thanks for the heads up.
-- David Tom Ogilvy wrote Note in Excel 97, that will raise an error (illegal operation) if the VBE has not been previously opened. That may not be a consideration for you, but it is not a general solution. -- Regards, Tom Ogilvy David Turner wrote in message ... Bob Phillips wrote To change the sheet code name use With Sheets(srcName) .Parent.VBProject.VBComponents(.CodeName) _ .Properties("_CodeName") = "abc" End With Found this tucked in one of my workbooks I forgot about: ThisWorkbook.VBProject.VBComponents(ActiveSheet.Co deName).Name = tgtName An alternative, anyway -- David |
| 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) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| 'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
