excel macro help

[Big Black Stilo]

I used to be so good at this but cant remember anything

I have an excel workbook im making, it has 24 worksheets in it. Im adding a button to each sheet that returns the main worksheet, but i want to hide the current sheet as it moves back to the main sheet and i dont want to have to make 24 slightly different macros to do this, is 1 macro than can do this no matter what worksheet its applied to?

thanks

 

[SeanW]

Should just be able to copy/paste the button and related function (macro) onto each sheet.

Can't remember the macro code, but it really isn't difficult to set up.

 

[Big Black Stilo]

i know how to do one macro for one sheet, but when i assign the macro onto a button on the other sheets, i get errors coz it names the original sheet... which is hidden.

is what your saying create the macro for one sheet then copy and paste the button once assigned the macro onto the other sheets it'll automatically change the sheet named in the macro? i know it can do this with formula

 

[Eklipze3k]

If you're doing it in a VB macro it's Sheets(SheetName).Select. Each button may have a different name though like CommandButton1, CommandButton2 etc but that coding copied onto each will work perfectly well.

 

[ycming]

Return_Macro()

activesheet=hide.
sheets(Main_sheet).select
End sub

 

[ycming]

Enter macro name here()

ActiveSheet.Hidden = True
sheets(Enter main sheet name here).select
End sub