how to write a macro independent of another

[zacuk]

Hi,

I have a macro which works fine. Then, I wanted to write another macro, so I clicked on Record Macro (in Code section of the Developer tab), gave it a name, stopped recording. The new macro name appears as expected in the code section of the Developer tab under Macros. HOWEVER, when I open this new darn macro to edit it, to my surprise, it also contains the previous macro in it which I want to run independently.

See, this is the 'tail end' of the first macro, which is still showing up (along with the full first macro, I have deleted most of which in the example below) in Macro 6 which I want to write and execute independent of the first macro:

.NumberFormat = "@"
.Columns.AutoFit
.Borders.Weight = 2
End With
End Sub



Sub Macro6()
'
' Macro6 Macro
'


'
End Sub

If I delete the first macro code from Macro 6, it removes the first macro from the Macros list altogether!!

Please help. Thanks

 

[FormR]

Hi, you can have more than one macro in a code module. They can still be executed independently.

 

[zacuk]

Hi FormR,

How would you refer to them when 'linking' a macro to a button in Excel please?

If it is an independent macro, one can simply click on it to assign it to the button.

Thanks

 

[philwojo]

Your new Marco is named Macro6, when you assign the Macro to your button just assign that Macro6 name and only that code will run, nothing else.

The view you have is just a container, it probably is separated by a line between the two macro's, even if it isn't you see the "End Sub" command, that ends the previous macro, so only what is between the 'Sub Macro6()' and the 'End Sub' for Macro6 will ever be executed when you call Macro6.

 

[FormR]

one can simply click on it to assign it to the button

Hi - you should be able to assign Macro6 to a button in the normal way.