opening a worksheet without showing excel components

B

bigdaddy3

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
 
F

FSt1

hi,
not sure but it sounds like you are running the macro from the vb editor.
try this instead.
Tool>macro>macros
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
 
B

bigdaddy3

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
 
Top