Questions & Answers for: close workbook

...wont be able to use it until the changes have been saved and the person who has exclusive use closes it. If you allow lots of people use of the workbook at the same time and they are all trying ...

...workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to ...

Macros Help PLZ Macros help14 Mar 2008 - I accidentally hit disable on my workbook then closed. Now when I try to open my workbook (that now has a xlms extention) I get This file is not a recognizable

...be saved due to internal errors. Program experences "Fatal Errors". Workbooks ALWAYS opened and closed together. Have tried "cleaning up" by moving select worksheets. all way to copying and ...

...close a workbook with macros in excel but leave the program ( excel ) open After you record your macro do the following. Open the excel file contains the macro. Go to tools and go to macro and click ...

...tab "Protection" and then check on "Lock" option. Click ok and close this dialog. Go to ribbon 'Review' and select "Protect sheet" Typing you password Saving and close your workbook and reopen

...various financial data. I also password protected the workbook. Prior to today, I had opened and closed the file several times without problems. However, on my last attempt to open the file I ...

...workbook loaded, then just delete it or rename it. The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART ...

when i open remote management showing a error message''error:1004'' please help me to solve this problem. his problem can occur when you give the workbook a defined name and then copy the worksheet ...

Workbook set r1 = Activesheet.range("A1?) set bk = workbooks.open("C:\Myfolder\Myfile.dbf") set r = bk.worksheets(1).Range("A1?).currentRegion r.copy r1 bk.close SaveChanges:=False end sub That is the