hi,
not sure but it sounds like you are running the macro from the vb editor.
try this instead.
Toolmacromacros
this will bring up a macro box.
select the macro you wish to run then click ok.
or just double click the macro you wish to run.

works for me in 97, 2k and xp.
regards
FSt1

"bigdaddy3" wrote:

is there anyway i can run a workbook that has macros and buttons to do all
the input and output,ie save,close etc but without showing the whole excel
program on screen ie, i just need to show my workbooks
--
BD3