Close Personal.xls after each macro

  • Thread starter Thread starter Brennan
  • Start date Start date
B

Brennan

Hello all,

Everytime I run a macro it opens my PERSONAL.xls sheet. I would like to
write code at the end of each macro which closes Personal.xls. What would
the code look like to do that? Thanks

Brennan
 
Personal.xls should always be open when there's an instance of Excel
running...do you mean that Personal.xls is visible after each macro?
If so just go Window>Hide to keep it hidden.

Cliff Edwards
 

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

Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Can I mass-change macro paths of tool buttons? 15
Digitally Signed Macros in Personal.XLS 3
Loop through all open workbooks except Personal.xls 5
Saving information to PERSONAL.XLS 1
Porting from Excel 2003 to Excel 2010 12
Create employee attendance db using personal.xls? 3
Switching workbooks with Personal.xls 3

Back
Top