Renaming Module Made Macros Not Run

[Shiremaid]

I have it fixed for the moment but am concerned about it possibly happening again because I don't know why it happened in the first place.

This is what happened:

In Excel 2007 I have a spreadsheet with a bunch of macros in it. (The spreadsheet is a list of Materials on Sheet1 which users can select items from to add to a form on Sheet 2).

In an effort to make editing the macros easier, I put all like macros together in separate modules which I then named. Not hard because I recorded and edited like macros at the same time so most of them were already properly grouped, I just re-named the module.

The next time a user opened the sheet, several macros were suddenly not working.

When I looked I found that for some reason the macro names had changed on only some of the macros to include the module name.

For instance:
In one module called A_Sort_304 I have macros:
Open_304
Close_304
Angle_304
Bar_304
Channel_304
Pipe_Tube_304
Plate_304
Sheet_304
Other_304

Bar_304 no longer worked. All of the others are perfectly fine and appear normally in my macro list but Bar_304 now shows as
A_Sort_304.Bar_304
Bar_304 was not the only one that was moved into this module from another one. Nor is it the only one moved from a particular module to this one.

So my questions are:

How did that happen?
Why did it only happen to 13 out of 82 macros in the workbook?
How can I make it not happen next time I make updates?

 

[CharlesChuckieCharles]

A_Sort_304.Bar_304 in the list suggests that you copied not moved and the Workbook holding the original is still in memory

 

[Norie]

You appear to be using names for the modules that are pretty similar to the subs in the modules, that's not really a good idea.

By the way, just curious, do all the modules have basically the same set of subs.

 

[Shiremaid]

Yes, there are nearly 2000 materials that the users want sorted into much smaller subsets so there are about 8 similar sets of macros.

I will look at using different names for the modules then as it's work in progress and hopefully that will help prevent further changes.

Thanks

You appear to be using names for the modules that are pretty similar to the subs in the modules, that's not really a good idea.

By the way, just curious, do all the modules have basically the same set of subs.

 

[Norie]

If these subs are similar perhaps you don't need so many.

How much do they differ?

For example, how does the Open_X sub from Module_X differ from Open_Y from Module_Y?

 

[Shiremaid]

Each of those subs filters the list of materials for the foremen.
I have learned some about If Thens (mostly from this forum) since I first set up the sheet, so it's a work in progress and I am hoping I can get the total number of macros down. I just don't want to have to worry about the buttons breaking down every time I change something.

If these subs are similar perhaps you don't need so many.

How much do they differ?

For example, how does the Open_X sub from Module_X differ from Open_Y from Module_Y?