CODEWITHSUNDEEP
vbaexcel
SoftTimur
SoftTimur

Reputation: 5540

Objects representing worksheets

It seems to me that normally objects representing worksheets are Sheet1, Sheet2, etc. And Sheet1.Name returns its name which could be modified either in Excel or VBA.

However, I see in the following workbook database_GEV_V_2_3.xls, the objects are Foglio1, Foglio2... And Foglio1.Name returns Home... Coud anyone tell me how this is possible? What did they do to name the sheet objects this way?

enter image description here

Edit1: Here is the available menu...

enter image description here

Upvotes: 0

Views: 38

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35863

How you can change it manually:

  • Goto VIEW-->Properties Window on menu bar (for Windows you can also press F4).
  • Select any sheet and change its Name property on Properties Window

How to change it programmatically:

ThisWorkbook.VBProject.VBComponents("Foglio1").Name = "newName"

where "Foglio1" is old name and "newName" is new name.

Upvotes: 2

Related Questions