ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Access to references in VBA (https://www.excelbanter.com/excel-programming/433399-access-references-vba.html)

jc

Access to references in VBA
 
:I have a project where I can see code windows. Under the tools menu item
References... is grayed out. What do I need to do to make the References
accessible?
--
CroceJC

Patrick Molloy[_2_]

Access to references in VBA
 
its greyed out if the project is protected. click on a new workbook and it
should become enabled

"jc" wrote:

:I have a project where I can see code windows. Under the tools menu item
References... is grayed out. What do I need to do to make the References
accessible?
--
CroceJC


Chip Pearson

Access to references in VBA
 
If the VBProject is protected, you'll need to unprotect it.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 10 Sep 2009 08:33:02 -0700, jc
wrote:

:I have a project where I can see code windows. Under the tools menu item
References... is grayed out. What do I need to do to make the References
accessible?


Barb Reinhardt

Access to references in VBA
 
IIRC, this also occurs when the workbook is shared. Turn off sharing to view
the code.

"jc" wrote:

:I have a project where I can see code windows. Under the tools menu item
References... is grayed out. What do I need to do to make the References
accessible?
--
CroceJC



All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com