Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Macro: "Reference not valid"

I have two macros that I cannot use, edit, or delete.

Excel ver. 7 for Windows 95 : Tools - Macro dialog box

One macro recently created, of the 3 in that box, works fine.

How can I delete the bad ones? I suspect them of causing trouble.

Thanks for any suggestions.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Macro: "Reference not valid"

On Mon, 19 Oct 2009 23:32:08 -0700, Mason C
wrote:

I have two macros that I cannot use, edit, or delete.

Excel ver. 7 for Windows 95 : Tools - Macro dialog box

One macro recently created, of the 3 in that box, works fine.

How can I delete the bad ones? I suspect them of causing trouble.

Thanks for any suggestions.


I solved my "reference not valid" problems by copying all seven sheets (using
upper left button to highlight the entire sheet ) from the troubled workbook to
a new workbook. The lost macros did not copy. It took a little work to erase
the old workbook filename from the chart data series references. And recreate
the macro I *did* want. All's clear now, thanks.
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
Pivot Table "Data source reference is not valid" error cause? Bill Neurohr Excel Discussion (Misc queries) 1 March 11th 09 10:16 PM
"Reference is not Valid" J Austin Excel Discussion (Misc queries) 0 September 2nd 08 06:49 PM
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 Milky Excel Worksheet Functions 1 August 20th 08 08:38 PM
"Reference not valid" error when I try to edit the macro in excel Yuvaraj Excel Discussion (Misc queries) 1 January 10th 08 08:32 PM
Pivot Table - Error "Reference Is Not Valid" Olly Excel Discussion (Misc queries) 0 May 22nd 07 09:27 AM


All times are GMT +1. The time now is 03:40 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"