Deleting old workbook data
 

I have a workbook that was created using an older file as the starting point.
Somewhere along the way information was deleting leaving behind defined
names and macros.

I have tried to delete these old macros but the delete button is grayed out
when I pull up the macro. If I try and edit the macro, I get a reference is
not valid message. These macros are often assigned to shortcut keys I
normally use, like control R or Control Y, so I must select via the menu or a
shortcut key on my tool bar.

When I copy a sheet mulitple times, I will get a message that the name
already exists in the destination worksheet. I have tried deleting defined
names, but it does not seem to get rid of the problem. I do not seem to find
the name that causes the message. I just have to select yes for each of the
names and then the sheet copies.

I can still use the workbook, it is just annoying to have to deal with these
old items each time. Any suggestions on how to eliminate these issues?

Deleting old workbook data
 

The easiest might be to create a new workbook, adding and renaming sheets to
reflect the same structure as the original.

then go to each sheet in the old and copy all the data and formulas and
paste them into the new workbook in an identical location.

This should get rid of all names and shortcut keys and macros.

--
Regards,
Tom Ogilvy




"Julie" wrote:

I have a workbook that was created using an older file as the starting point.
Somewhere along the way information was deleting leaving behind defined
names and macros.

I have tried to delete these old macros but the delete button is grayed out
when I pull up the macro. If I try and edit the macro, I get a reference is
not valid message. These macros are often assigned to shortcut keys I
normally use, like control R or Control Y, so I must select via the menu or a
shortcut key on my tool bar.

When I copy a sheet mulitple times, I will get a message that the name
already exists in the destination worksheet. I have tried deleting defined
names, but it does not seem to get rid of the problem. I do not seem to find
the name that causes the message. I just have to select yes for each of the
names and then the sheet copies.

I can still use the workbook, it is just annoying to have to deal with these
old items each time. Any suggestions on how to eliminate these issues?

Deleting old workbook data
 

Unfortuanately the file is rather huge and it would take considerable effort
to recreate from scratch. That is probably the reason it was created using
an old worksheet in the past. My guess is that certain elements of the
workbook were needed and so the file was used as a starting point. There is
so much old data like the defined names and dead macros that it gets a little
irritating, but not impossible to use as is.

Any suggestions on if it is possible to get rid of this old information
(macros, names, etc.) would be greatly appreciated. Thanks for your time.

"Tom Ogilvy" wrote:

The easiest might be to create a new workbook, adding and renaming sheets to
reflect the same structure as the original.

then go to each sheet in the old and copy all the data and formulas and
paste them into the new workbook in an identical location.

This should get rid of all names and shortcut keys and macros.

--
Regards,
Tom Ogilvy




"Julie" wrote:

I have a workbook that was created using an older file as the starting point.
Somewhere along the way information was deleting leaving behind defined
names and macros.

I have tried to delete these old macros but the delete button is grayed out
when I pull up the macro. If I try and edit the macro, I get a reference is
not valid message. These macros are often assigned to shortcut keys I
normally use, like control R or Control Y, so I must select via the menu or a
shortcut key on my tool bar.

When I copy a sheet mulitple times, I will get a message that the name
already exists in the destination worksheet. I have tried deleting defined
names, but it does not seem to get rid of the problem. I do not seem to find
the name that causes the message. I just have to select yes for each of the
names and then the sheet copies.

I can still use the workbook, it is just annoying to have to deal with these
old items each time. Any suggestions on how to eliminate these issues?

Deleting old workbook data
 

http://www.cpearson.com/excel/vbe.htm


You can also download Jan Karel Pieterse's free name manager

http://www.jkp-ads.com/Download.asp


note that "ads" stands for Application Development Services - bad name
choice.
--
Regards,
Tom Ogilvy


"Julie" wrote:

Unfortuanately the file is rather huge and it would take considerable effort
to recreate from scratch. That is probably the reason it was created using
an old worksheet in the past. My guess is that certain elements of the
workbook were needed and so the file was used as a starting point. There is
so much old data like the defined names and dead macros that it gets a little
irritating, but not impossible to use as is.

Any suggestions on if it is possible to get rid of this old information
(macros, names, etc.) would be greatly appreciated. Thanks for your time.

"Tom Ogilvy" wrote:

The easiest might be to create a new workbook, adding and renaming sheets to
reflect the same structure as the original.

then go to each sheet in the old and copy all the data and formulas and
paste them into the new workbook in an identical location.

This should get rid of all names and shortcut keys and macros.

--
Regards,
Tom Ogilvy




"Julie" wrote:

I have a workbook that was created using an older file as the starting point.
Somewhere along the way information was deleting leaving behind defined
names and macros.

I have tried to delete these old macros but the delete button is grayed out
when I pull up the macro. If I try and edit the macro, I get a reference is
not valid message. These macros are often assigned to shortcut keys I
normally use, like control R or Control Y, so I must select via the menu or a
shortcut key on my tool bar.

When I copy a sheet mulitple times, I will get a message that the name
already exists in the destination worksheet. I have tried deleting defined
names, but it does not seem to get rid of the problem. I do not seem to find
the name that causes the message. I just have to select yes for each of the
names and then the sheet copies.

I can still use the workbook, it is just annoying to have to deal with these
old items each time. Any suggestions on how to eliminate these issues?

Deleting old workbook data
 

I think Jan Karel rejected:
Systems Professional Application Mechanized Routines Universal Solutions

Before he settled on that www.jkp-ads.com name.

www.jkp-SPAM-R-Us.com
just didn't seem right.

(Yeah, I got lots of time (too much??) on my hands!)



Tom Ogilvy wrote:

http://www.cpearson.com/excel/vbe.htm

You can also download Jan Karel Pieterse's free name manager

http://www.jkp-ads.com/Download.asp

note that "ads" stands for Application Development Services - bad name
choice.
--
Regards,
Tom Ogilvy

"Julie" wrote:

Unfortuanately the file is rather huge and it would take considerable effort
to recreate from scratch. That is probably the reason it was created using
an old worksheet in the past. My guess is that certain elements of the
workbook were needed and so the file was used as a starting point. There is
so much old data like the defined names and dead macros that it gets a little
irritating, but not impossible to use as is.

Any suggestions on if it is possible to get rid of this old information
(macros, names, etc.) would be greatly appreciated. Thanks for your time.

"Tom Ogilvy" wrote:

The easiest might be to create a new workbook, adding and renaming sheets to
reflect the same structure as the original.

then go to each sheet in the old and copy all the data and formulas and
paste them into the new workbook in an identical location.

This should get rid of all names and shortcut keys and macros.

--
Regards,
Tom Ogilvy




"Julie" wrote:

I have a workbook that was created using an older file as the starting point.
Somewhere along the way information was deleting leaving behind defined
names and macros.

I have tried to delete these old macros but the delete button is grayed out
when I pull up the macro. If I try and edit the macro, I get a reference is
not valid message. These macros are often assigned to shortcut keys I
normally use, like control R or Control Y, so I must select via the menu or a
shortcut key on my tool bar.

When I copy a sheet mulitple times, I will get a message that the name
already exists in the destination worksheet. I have tried deleting defined
names, but it does not seem to get rid of the problem. I do not seem to find
the name that causes the message. I just have to select yes for each of the
names and then the sheet copies.

I can still use the workbook, it is just annoying to have to deal with these
old items each time. Any suggestions on how to eliminate these issues?

--

Dave Peterson

Deleting old workbook data
 

I can see where he might have been justifiably concerned with that first
option. <g

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
I think Jan Karel rejected:
Systems Professional Application Mechanized Routines Universal Solutions

Before he settled on that www.jkp-ads.com name.

www.jkp-SPAM-R-Us.com
just didn't seem right.

(Yeah, I got lots of time (too much??) on my hands!)



Tom Ogilvy wrote:

http://www.cpearson.com/excel/vbe.htm

You can also download Jan Karel Pieterse's free name manager

http://www.jkp-ads.com/Download.asp

note that "ads" stands for Application Development Services - bad name
choice.
--
Regards,
Tom Ogilvy

"Julie" wrote:

Unfortuanately the file is rather huge and it would take considerable
effort
to recreate from scratch. That is probably the reason it was created
using
an old worksheet in the past. My guess is that certain elements of
the
workbook were needed and so the file was used as a starting point.
There is
so much old data like the defined names and dead macros that it gets a
little
irritating, but not impossible to use as is.

Any suggestions on if it is possible to get rid of this old
information
(macros, names, etc.) would be greatly appreciated. Thanks for your
time.

"Tom Ogilvy" wrote:

The easiest might be to create a new workbook, adding and renaming
sheets to
reflect the same structure as the original.

then go to each sheet in the old and copy all the data and formulas
and
paste them into the new workbook in an identical location.

This should get rid of all names and shortcut keys and macros.

--
Regards,
Tom Ogilvy




"Julie" wrote:

I have a workbook that was created using an older file as the
starting point.
Somewhere along the way information was deleting leaving behind
defined
names and macros.

I have tried to delete these old macros but the delete button is
grayed out
when I pull up the macro. If I try and edit the macro, I get a
reference is
not valid message. These macros are often assigned to shortcut
keys I
normally use, like control R or Control Y, so I must select via
the menu or a
shortcut key on my tool bar.

When I copy a sheet mulitple times, I will get a message that the
name
already exists in the destination worksheet. I have tried
deleting defined
names, but it does not seem to get rid of the problem. I do not
seem to find
the name that causes the message. I just have to select yes for
each of the
names and then the sheet copies.

I can still use the workbook, it is just annoying to have to deal
with these
old items each time. Any suggestions on how to eliminate these
issues?

--

Dave Peterson

Deleting old workbook data
 

I'll be here all week. Enjoy the veal.

Tom Ogilvy wrote:

I can see where he might have been justifiably concerned with that first
option. <g

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
I think Jan Karel rejected:
Systems Professional Application Mechanized Routines Universal Solutions

Before he settled on that www.jkp-ads.com name.

www.jkp-SPAM-R-Us.com
just didn't seem right.

(Yeah, I got lots of time (too much??) on my hands!)



Tom Ogilvy wrote:

http://www.cpearson.com/excel/vbe.htm

You can also download Jan Karel Pieterse's free name manager

http://www.jkp-ads.com/Download.asp

note that "ads" stands for Application Development Services - bad name
choice.
--
Regards,
Tom Ogilvy

"Julie" wrote:

Unfortuanately the file is rather huge and it would take considerable
effort
to recreate from scratch. That is probably the reason it was created
using
an old worksheet in the past. My guess is that certain elements of
the
workbook were needed and so the file was used as a starting point.
There is
so much old data like the defined names and dead macros that it gets a
little
irritating, but not impossible to use as is.

Any suggestions on if it is possible to get rid of this old
information
(macros, names, etc.) would be greatly appreciated. Thanks for your
time.

"Tom Ogilvy" wrote:

The easiest might be to create a new workbook, adding and renaming
sheets to
reflect the same structure as the original.

then go to each sheet in the old and copy all the data and formulas
and
paste them into the new workbook in an identical location.

This should get rid of all names and shortcut keys and macros.

--
Regards,
Tom Ogilvy




"Julie" wrote:

I have a workbook that was created using an older file as the
starting point.
Somewhere along the way information was deleting leaving behind
defined
names and macros.

I have tried to delete these old macros but the delete button is
grayed out
when I pull up the macro. If I try and edit the macro, I get a
reference is
not valid message. These macros are often assigned to shortcut
keys I
normally use, like control R or Control Y, so I must select via
the menu or a
shortcut key on my tool bar.

When I copy a sheet mulitple times, I will get a message that the
name
already exists in the destination worksheet. I have tried
deleting defined
names, but it does not seem to get rid of the problem. I do not
seem to find
the name that causes the message. I just have to select yes for
each of the
names and then the sheet copies.

I can still use the workbook, it is just annoying to have to deal
with these
old items each time. Any suggestions on how to eliminate these
issues?

--

Dave Peterson

--

Dave Peterson