2012年3月4日日曜日

Change Sheet Code Name In VBA

Sheet's "codeName" is very important in VBA.
Application User often changes a sheet name,but a developer often want not for sheet to be changed its name.

Then we shoud use "codeName" in VBA.
When use it,we often want to change code name dynamically when application runs.
The below way is this solusions.






 objWorkbook.VBProject.VBComponents(objSheet.CodeName).Name = "custmizedName"

0 件のコメント: