Solved: MROUND Function

[gimli]

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]

Try putting

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

in the Workbook_Open module.

HTH.

Lincoln

[gimli]

Ahh very nice!

works perfect

thanks much