ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Close personal projekt workbook (https://www.excelbanter.com/excel-discussion-misc-queries/164753-close-personal-projekt-workbook.html)

alvin Kuiper

Close personal projekt workbook
 
Hi
Is there away to close the personal projekt workbook
In Excel

Dave Peterson

Close personal projekt workbook
 
Like Personal.xls (in the USA version of excel)?

You can unhide it if it's hidden (window|unhide in xl2003)
then close it (and don't save!)

Or you could do this:
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
workbooks("personal.xls").close savechanges:=false 'or true???

Then back to excel.

You'll have to use the correct name for your personal.xls workbook.

alvin Kuiper wrote:

Hi
Is there away to close the personal projekt workbook
In Excel


--

Dave Peterson


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com