View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert Rosenberg Robert Rosenberg is offline
external usenet poster
 
Posts: 11
Default Duplicate Subroutines

Are you not getting the prompt to Enable/Disable Macros? Is it freezing
before that prompt?

If you are getting the prompt you can click Disable, then go in and change
the name (and save).

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel

"Gary Elsner" wrote in message
...

I'm using Excel 2002 and by mistake I copied a VBA
subroutine and did not rename the copy.

When I open the Workbook the hour glass goes around and
around. And doesn't allow me to edit my macros and change
the name of this duplicate subroutine.

How can I get the hour glass to stop so I can change the
name?

I tried using Alt/Control/Delete to stop the task, but it
stops it and closes out the Workbook.

All suggestions are welcome!!

/ Gary E.