opening a worksheet without showing excel components
 

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

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

Hi FST1
Thanks for that but its not what i need ive had a reply from other
source that has given me the code to hide excel but thanks for your help
--
BD3


"FSt1" wrote:

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