How to manipulate the codename of Thisworkbook and sheet in Excel

As long as you have permissions to the file, there's no question of how you log in to your computer.

What are the permissions? Read, write, rewrite, traverse the file list, do not have the permission to delete, full control, etc.

These won't work for your files.

So Area A and Area B are broken.

Let's talk about modules and thisworkbook.

When I write ** myself, I often put it in thisworkbook.

The standard module, which is what we use to "plug in-

Module "Module 1", "Module 2", these standard modules do not have their own unique methods and events except for some automatic events such as auto open. The public variables declared in the standard modules can be accessed and called directly by all other modules.

For example, I have a ** that processes the data in the sheet1 table, so this ** can be directly placed in the sheet1 module. And I have an event that I want to use workbook open, so this event must be placed in the thisworkbook module. So what module to write in depends on what methods and events you need to use.

In general, there are some common methods that we can put in a standard module. Custom functions must be placed in a standard module.

So the content of your question is specifically placed in **, not necessary, so the problem of the module and thisworkbook has been solved.

So the questions you guessed, I'm sorry I didn't hit all of them.

According to what you said, it should be related to the macro security permissions of the computer itself, and you can start from this aspect.

After all, I don't have your environment, so it's difficult to test.

This problem is too vague, and the programming problems are all specific problems and analysis.

The name of the worksheet is its name.

I'm guessing you're asking about the difference between name and codename, right?

For example, in Engineering Explorer.

sheet1 (payroll).

sheet1 is codename,"Payroll"is its name, and you also need to pay attention to sheets(1) and sheets("1").

The former has the index number in parentheses, and the latter is name

height = cells(i, 1).height - 2

width = cells(i, 2).width - 2

**All of them are numbered in column C Modify them by yourself cells(i,3) 3 represents Mindan column C and 4 generations of Qin take the table D column.

Take a look at the worksheet with wood and sheet2, note that this sheet2 is the worksheet table name displayed in the foreground, which is case-sensitive and space-sensitive.

The reason for this problem is that the specified sheet cannot be found, and the sheet named "sheet2" does not exist.

It is recommended to check the name of the following ** and whether there is "sheet2".

"sheet1", "sheet3", "sheet5")).copy

One sentence will do, put one of them"sheet1", "sheet3", "sheet5"Swap it out with the worksheet name you need.

One of your excels is equivalent to a notebook, then sheet1, sheet2, and sheet3 are equivalent to separate functions that you can't achieve if you don't set functions in c3. If you set up a function, you can.

sub Add file().

dim aa =after:=sheets(a)

worksheets(a + 1).name = "The name you want abc"

end sub

Add a new one and then change the name.

For example="abc"

Instead of using macros, create a new sheet and rename it to the name you want

1.Click on a sheet label (e.g., click the Worksheet command on the Insert menu) and the newly inserted worksheet will precede sheet2.

2.Rename: Double-click the sheet tab to change it.

Save it as. XLAM format, save to the system default folder, and then go to Development Tools - Add-ons - check it in the available loading macros, and OK.

Ah search view and I can module of the mulberry card on the year enough roil on the company's tube.