How to save add-in on Excel 2010

[malka]

I would like to save an add-in build as VBA on Excel 2010. The function unhides all the hidden TABS on a Excel worksheet.

Thanks

[zmbd]

I have just such a workbook for my lab that handles common calculations and other functions.

It's not very easy to accomplish for V2010 as you also have to provide a way for the user to run your code and access any custom functions.

So, first you'll really need to learn about how to design a custom ribbon.
Second you will need to learn how to expose code and functions from a workbook/add-in without Ribbon callback globally.
Finally you'll have to decide on a means of distribution.

All of these are very much beyond what this forum is about; however, your favorite search engine should be able to turn up a few tutorials. Once you have these and have read them, try your hand and post back with your problems as they occur.

[malka]

I have the VBA sub function, all I need to know is how to save it as add-in on Excel 2010

Thanks

[malka]

VBA function to unhide all tabs in a worksheet

Sub UnhideAllSheets()  
    Dim wsSheet As Worksheet          
    For Each wsSheet In ActiveWorkbook.Worksheets      
        wsSheet.Visible = xlSheetVisible       
    Next wsSheet       
End Sub

[zmbd]

the VBA is irrelevant
Open your workbook containing the VBA
Remove any unused worksheets
file save as
select the "add-in" (.xlam) option.
Be mindful of the of the file path.
click save

- please be careful as to how you word your posts. Anything that could be taken as an outright demand for code/completed project or other answers can result in the entire thread being closed and deleted.
Out right requests for full code are against site policy.
Bytes is not a code nor homework service. Please read the FAQ and posting guidelines before re-posting your question.
>> Before Posting (VBA or SQL) Code.
>> How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!.
>> POSTING_GUIDELI NES: Please Read Carefully Before Posting to a Forum.