Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet in Excel 2000 that has a reference set to "Microsoft
Forms 2.0 Object Library." This spreadsheet has no forms in it -- it consists of one sheet, with some calculations and two short macros. The spreadsheet was created in 1998, so it's possible at one time there were forms in it, but there aren't now. I am trying to check the box to remove the reference to it, and I'm getting a message that says "Can't remove control or reference; in use." I can't find anyplace where it is in use. I've even gone so far as to delete ALL the rows in the spreadsheet below the initial four column headings, thinking I'd just type the calcs back in and copy it down -- so whatever might have been in there and not been visible SHOULD have gone away -- but hasn't. How can I get this reference to go away? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting/removing unused rows in a worksheet | Excel Discussion (Misc queries) | |||
Removing reference generates type mismatch error | Excel Programming | |||
Removing $$ Reference in cells | Excel Worksheet Functions | |||
Removing unused or blank rows and columns | Excel Discussion (Misc queries) | |||
Removing a reference | Excel Programming |