How can I create a worksheet in a routine and set the code name at

G

Guest

Gurus please help me out.
How can I create a worksheet in a routine and set the code name at the same
time.
I presently have a routine that ran fine from the immediate window, but
fails when I call it from my form. I got the "out of range" error.
 
N

NickHK

I seem to remember there are some restrictions on this, because some
propertties do not exist in the VBE until they are used.
So if you are creating a WS, whilst it exist in the WB (you can see it), it
does "exist" for the purposes of the VBE.
From the Immediate window it will work, because the VBE is open/visible and
consequently that object must be present.
IIRC, you can call some property/method/anything on the newly created WS
first, then the .CodeName will be available.

NickHK
 
B

Bob Phillips

IIRC, you can call some property/method/anything on the newly created WS
first, then the .CodeName will be available.
Click to expand...

Force a recompile

Application.VBE.CommandBars.FindControl(ID:=578).Execute
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

non basic code in call stack 3
Inserting code to call a routine when creating a worksheet 7
Sort Routine Macro for Excel Worksheet 1
How do you Determine if a Worksheet is protected? 2
passing a value back to original routine 6
Recursive Sub Routine? 1
Create a new worksheet and name it 1
How can I load a user form from within a worksheet subroutine? 4

Top