Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default What is this macro?

In every excel file opening, I also found this dialogue. What is it? How can I delete this?

It increases the file size to twice or triple

Code:
http://i433.photobucket.com/albums/qq56/sharephotoonline/4Rum/12-23-20095-25-10PM.png
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
Default What is this macro?

Those are not macros. They are what is known as Named Ranges. Search
Excel's Help to learn more about those things.

But in this case, the worksheets or rows/columns with those particular Named
ranges have been deleted at some time. You could go through that entire list
and for any entries that show a #REF error, you could select it and use the
[Delete] option to remove its definition from the workbook.

I suspect that somewhere in the distant past you had a workbook that had
those ranges defined, and other workbooks were based on it, and over time,
the worksheets or cells they referred to were deleted, leaving the name
definition behind, but with nothing to actually refer to.

"finditsol" wrote:


In every excel file opening, I also found this dialogue. What is it? How
can I delete this?

It increases the file size to twice or triple


Code:
--------------------
http://i433.photobucket.com/albums/q...95-25-10PM.png
--------------------




--
finditsol
.

Reply
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
Macro recorded... tabs & file names changed, macro hangs Steve Excel Worksheet Functions 3 October 30th 09 11:41 AM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 3 February 5th 07 08:22 PM
Macro needed to Paste Values and prevent Macro operation thunderfoot Excel Discussion (Misc queries) 1 June 11th 05 12:44 AM
Macro needed to Paste Values and prevent Macro operation thunderfoot Excel Discussion (Misc queries) 0 June 10th 05 03:38 PM


All times are GMT +1. The time now is 04:30 AM.

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

About Us

"It's about Microsoft Excel"