Hi,

While trying to open this excel file (which has some VBA code) on som
PCs it gives a run time error. The details of the error

Runtime Error '2147467259 (80004005)':
Method 'OnAction' of object '_CommandBarButton' failed.

The file has some VBA code for open event of the file as well. If th
analysis toolpak is not checked, I check it while opening the file
Also I set some parameters in a sheet in this event.

Any help would be appreciated.

- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=26879