LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Removing unused reference

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting/removing unused rows in a worksheet Tom Excel Discussion (Misc queries) 3 November 25th 09 04:58 PM
Removing reference generates type mismatch error quartz[_2_] Excel Programming 4 December 14th 05 03:50 PM
Removing $$ Reference in cells Castor Excel Worksheet Functions 1 August 13th 05 12:36 AM
Removing unused or blank rows and columns Mark F Excel Discussion (Misc queries) 2 December 23rd 04 02:39 AM
Removing a reference Andrew B[_3_] Excel Programming 1 July 22nd 04 01:32 PM


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"