Welcome to the iTechForums.
If this is your first visit, be sure to check out the
FAQ by clicking the link above.
You may have to
register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
To register now click here.
|
Latest Threads
Advertisements
Forum Statistics
Threads:
Posts: 1
Members:
Number of Users Online:
Welcome to our newest member, |
|
 |
05-06-2008, 05:25 PM
|
|
Junior Member
|
|
Join Date: May 2008
Posts: 10
|
|
In Excel, how can I force it to update the CodeName property of a new sheet
without the Visual Basic Editor? In Excel 2003 The CodeName property of a new sheet appears to be blank until the Visual Basic editor is opened. This is a problem for a program I am writing because it wants to use the CodeName property for new sheets without the user having to have the Visual Basic editor open, and without having to check the "Trust Access to Visual Basic project" tab of the security settings. I found a solution, but unfortunately it is unacceptable because it requires the Trust Access to VB Project option to be selected. Please help if you can! Thanks very much.
I subsequently found a fairly complete discussion of this issue that answered my question here:
http://www.pcreview.co.uk/forums/thread-961793.php
Tim, thanks for your answer. I agree with you when you say the sheet name should be used instead of the CodeName, although not for the reason you state. The CodeName can be changed in runtime but only if the user has enabled "Trust Access to the Visual Basic Project" via the Macro / Security options of Excel.
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
All times are GMT. The time now is 08:00 PM.
