I have a sheet where I originally created a global const as:

Global Const RAMPUP = "RU"

Well I decided that rather than that I wanted to do an enumeration. So I
deleted the global const and created:

Public enum TestTypes
RampUp
end enum

Except that after typing VBA gave me this:

Public enum TestTypes
RAMPUP
end enum

In fact, everytime I type rampup in the code it becomes capitalized. I did a
search and it exists nowhere in my code. Excel doesn't show it in the object
browser, and I restarted Excel, but it seems to have a die hard memory that
rampup = RAMPUP. It's done this with 3 other variables I made Global
constants and then deleted. Is there a way to stop this from happening?


--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003