PDA

View Full Version : Solved: MROUND Function



gimli
05-19-2010, 06:22 AM
Hey all,

So im using MROUND to round a number to the nearest .125". Works fine but the problem is all users need to load the analysis tool pack for it to work.

Is there anyway to use VBA to enable the tool pack if it isnt aready enabled?

or I guess this will work

=ROUND(Q17*8,0)/8


thanks mucho grande

lynnnow
05-20-2010, 02:38 AM
Try putting

Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
End sub

in the Workbook_Open module.

HTH.

Lincoln

gimli
05-20-2010, 04:06 AM
Ahh very nice!

works perfect

thanks much