Hi there,
Can anyone correct my syntax here please, I am creating a macro that creates a new sheet and names it based on a cell value. I can get it to rename the tab name with this code, but I can't seem to get it to work to rename the sheet object name.
How it .CodeName supposed to be used.
Please Login or Register to view this content.
Kind regards
Rob
Worksheet CodeNames are read only. They're defined by Excel when the sheet is created and cannot be changed.
EDIT: Apparently there is a "trick" to change the CodeName, but I haven't tried it.
Change the Sheet’s CodeName in Excel using VBA
Last edited by AlphaFrog; 06-29-2015 at 10:55 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Can you provide a non-VBA example of what a sheet name is originally, what the cell value you find might be, and what the desired new sheetname would be?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks