Rename VBProject in Excel 2007

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Rename VBProject in Excel 2007

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 18th, 2007, 08:47 AM

chunchoazul chunchoazul is offline

chunchoazul is offline

Registered User

Join Date: May 2007

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Rename VBProject in Excel 2007

Hi,
How can rename VBProject in Excel 2007?
The following code example works fine in Excel 2003, but not in Excel 2007.

Sub rename()
ThisWorkbook.VBProject.Name = "NewName"
End Sub

Thanks for your Help.
Chuncho

Old

May 21st, 2007, 12:41 AM

vemaju

vemaju is offline

Friend of Wrox

Join Date: Oct 2003

Posts: 168

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Hi,

You must change Excel Trust Center Settings.
Check Trust access to the VBA project object model.
You can find it Trust Center - Macro Settings.

-vemaju

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2007 vba UDF	DavidReese	BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3	1	February 24th, 2009 01:10 AM
Excel 2000 upgrade to Excel 2007	poyserr	Excel VBA	0	October 27th, 2008 10:51 AM
excel rename and move files	ahzeri	Excel VBA	1	October 28th, 2007 09:27 PM