| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How remove invalid references in ToolsReferences drop down box? | Excel Programming | |||
| How to convert all 3d references to normal references in a workboo | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| References to ADO library for ACCESS connection | Excel Programming | |||
Hybrid Mode
