copying Workbooks...

I guess that's about as broad as I can make it.

Hi, I'm new here and not very savvy with Excel (as the name implies)

I am working on a project where someone has created 6 forms within a workbook on top of a previous workbook. So although the formatting and wording is new, underlying is a bunch of name definitions and such.

How do I clean out the stuff from the previous work?

I tried moving the sheets to a new workbook, but the underlying stuff just followed along.

Any help would be great!

TIA~
NES

When I look at these sheets in VBA they are not in the order that they are in the workbook. For example:

Looking at the tabs on the workbook
Notes, Documents, Desc. of Op, Cklist, Subs.

now when you open VBA

it'll say (sheet 1 - Desc. of Op)
(sheet 2 - Cklist)
(sheet 3 - Notes)

see the order is not right..........why? How do I fix it? Does it matter? I imagine it must matter somewhere.

Since you can change the position of the sheets in the workbook there is nothing inconsistent in what you're seeing. It's telling you that the 'Desc. of Op' sheet was the first sheet to be created, 'Clkist' the second one etc.

In VBA there are three ways of referencing a sheet and as long as you understand the differences, it really doesn't matter which method you use.

Sheets(2).Activate will make the second sheet tab counting from the left the active sheet.

Sheet3.Activate will use the VBA name and activate the third sheet that was added after the workbook was first created

Sheets("A").Activate will activate the sheet with the tab name "A"


As to your other question about getting rid of names, use the Insert--Name--Define Delete option.

or if you use range names a lot and want an Add In that is much superior to the standard XL Name functionality you should have a look at 'Name Manager'. It's an extremely powerful and useful Add In for handling, filtering, changing, finding and doing many other things with Range Names. It's the functionality Microsoft forgot about. Useful particularly as you build workbooks that contain many names.

It can be found at:

http://www.decisionmodels.com/Downloads.htm#namemanager

Credits to Jan Karel Pieterse, and Charles Williams of Decisions Models.