ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBE ToolsReferences (https://www.excelbanter.com/excel-programming/354190-vbe-tools-references.html)

Bill Martin[_2_]

VBE ToolsReferences
 
Having recently converted to Excel 2003 from '97 I'm slightly stumped. I
need to add a reference to another one of my XLS files into my VBE
environment. When I click on Tools though, the References button is grayed
out.

Trolling through the help files simply tells me to click ToolsReferences
to add what I want. I don't see any help on why that option is not
available to me. Presumably some bit of configuration somewhere in the new
system isn't right but I've been unable to locate it. Sound familiar?

Thanks.

Bill

Charlie

VBE ToolsReferences
 
By any chance is a macro trying to run or is paused? Try clicking on the
square "Reset" button.

"Bill Martin" wrote:

Having recently converted to Excel 2003 from '97 I'm slightly stumped. I
need to add a reference to another one of my XLS files into my VBE
environment. When I click on Tools though, the References button is grayed
out.

Trolling through the help files simply tells me to click ToolsReferences
to add what I want. I don't see any help on why that option is not
available to me. Presumably some bit of configuration somewhere in the new
system isn't right but I've been unable to locate it. Sound familiar?

Thanks.

Bill


Bill Martin[_2_]

VBE ToolsReferences
 
You may well be right. I went into the file just now to look at it again
and it works properly now. You've probably put your finger on the problem.

Thanks.

Bill
-----------------------
On Thu, 23 Feb 2006 12:05:17 -0800, Charlie wrote:

By any chance is a macro trying to run or is paused? Try clicking on the
square "Reset" button.

"Bill Martin" wrote:

Having recently converted to Excel 2003 from '97 I'm slightly stumped. I
need to add a reference to another one of my XLS files into my VBE
environment. When I click on Tools though, the References button is grayed
out.

Trolling through the help files simply tells me to click ToolsReferences
to add what I want. I don't see any help on why that option is not
available to me. Presumably some bit of configuration somewhere in the new
system isn't right but I've been unable to locate it. Sound familiar?

Thanks.

Bill



All times are GMT +1. The time now is 01:17 PM.

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