opening a worksheet without showing excel components

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close all without saving and exit without prompts 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Auto worksheet name? 1
autofilters on worksheets within workbook 4
Auto worksheet name? 1
Excel 2003 - open work book useage agreement 3
MS Excel, Location: Defined Names 1
Disable X button on excel 6

Back
Top