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 件のコメント:
コメントを投稿