Executing modules from any workbook

[ToriHabitatForHumanity]

I wrote several modules in a workbook called Book1.xlsm. They worked perfectly. I saved the file as an addin. In excel I place a check by this file in excel add-ins. I open a new file and run a module. I get no results, and sometimes an error message. What am I doing wrong? Thanks for any assistance. Here is a simple module for example:

Sub Fractionate()

''sets column format to fractional
'
   Set ws = ThisWorkbook.Sheets("Sheet1")
'
ws.Columns("A:b").NumberFormat = "# ?/?"

End Sub

 

[welshgasman]

This is the Access forum?

 

[Joe4]

I have moved this question from the Microsoft Access forum to the Excel Questions forum, as it definitely appears to be an Excel question!

 

[Joe4]

To answer your question, if you are saving this code as an Add-In, I think you will want to change all your references to "ThisWorkbook" (which is the Workbook the VBA code is stored in) to "ActiveWorkbook" (which is the Excel workbook that is active when you try running the code).

 

[ToriHabitatForHumanity]

Thanks so much. This works.

 

[Joe4]

You are welcome.

Many times "ThisWorkbook" and "ActiveWorkbook" are "one and the same", but not in the case where you use Add-Ins.