Microsoft KB Archive/101761: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - ">" to ">")
 
(2 intermediate revisions by the same user not shown)
Line 11: Line 11:
* Microsoft Excel for the Macintosh, version 4.0
* Microsoft Excel for the Macintosh, version 4.0


Page 145 of the "Function Reference," version 4.0, states that if you use the FALSE argument with the FILE.CLOSE() function, the function will close a workbook without saving changes. This information is not entirely correct. If you use the FILE.CLOSE() command in an auto-close macro in a workbook, you are prompted to save changes when you choose Close Workbook from the File menu.
Page 145 of the "Function Reference," version 4.0, states that if you use the FALSE argument with the FILE.CLOSE() function, the function will close a workbook without saving changes. This information is not entirely correct. If you use the FILE.CLOSE() command in an auto-close macro in a workbook, you are prompted to save changes when you choose Close Workbook from the File menu.


When you use the =FILE.CLOSE(FALSE) macro command in an auto-close macro and you close the workbook by choosing Close Workbook from the File menu, the auto-close macro will run but you are prompted to save changes to the workbook file. This occurs even if you precede the command with the ERROR(FALSE) command.
When you use the =FILE.CLOSE(FALSE) macro command in an auto-close macro and you close the workbook by choosing Close Workbook from the File menu, the auto-close macro will run but you are prompted to save changes to the workbook file. This occurs even if you precede the command with the ERROR(FALSE) command.
Line 19: Line 19:
If you run the auto-close macro by choosing Run from the Macro menu, the macro will close the workbook file as expected, without confirmation to save changes, even if changes to the documents have been made.
If you run the auto-close macro by choosing Run from the Macro menu, the macro will close the workbook file as expected, without confirmation to save changes, even if changes to the documents have been made.


Therefore, to keep from getting the "Save Changes In <document name>?" dialog box, do not run the macro as an auto-close macro. Instead, run the macro by choosing Run from the Macro menu, by assigning it to a button tool, or by running it from a custom menu.
Therefore, to keep from getting the "Save Changes In <document name>?" dialog box, do not run the macro as an auto-close macro. Instead, run the macro by choosing Run from the Macro menu, by assigning it to a button tool, or by running it from a custom menu.


== REFERENCES ==
== REFERENCES ==


&quot;Function Reference,&quot; version 4.0, pages 135, 145
"Function Reference," version 4.0, pages 135, 145


{|
{|
Line 37: Line 37:
<br />
<br />
<br />
<br />
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
</blockquote>
</blockquote>
<span>Last reviewed: September 12, 1996</span><br />
<span>Last reviewed: September 12, 1996</span><br />
[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br />
[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br />
|}
|}

Latest revision as of 09:15, 20 July 2020

Microsoft Knowledge Base

Excel: FILE.CLOSE(FALSE) Command Doesn't Work in Workbook

Last reviewed: September 12, 1996
Article ID: Q101761

The information in this article applies to:

  • Microsoft Excel for Windows, versions 4.0, 4.0a
  • Microsoft Excel for the Macintosh, version 4.0

Page 145 of the "Function Reference," version 4.0, states that if you use the FALSE argument with the FILE.CLOSE() function, the function will close a workbook without saving changes. This information is not entirely correct. If you use the FILE.CLOSE() command in an auto-close macro in a workbook, you are prompted to save changes when you choose Close Workbook from the File menu.

When you use the =FILE.CLOSE(FALSE) macro command in an auto-close macro and you close the workbook by choosing Close Workbook from the File menu, the auto-close macro will run but you are prompted to save changes to the workbook file. This occurs even if you precede the command with the ERROR(FALSE) command.

WORKAROUND

If you run the auto-close macro by choosing Run from the Macro menu, the macro will close the workbook file as expected, without confirmation to save changes, even if changes to the documents have been made.

Therefore, to keep from getting the "Save Changes In <document name>?" dialog box, do not run the macro as an auto-close macro. Instead, run the macro by choosing Run from the Macro menu, by assigning it to a button tool, or by running it from a custom menu.

REFERENCES

"Function Reference," version 4.0, pages 135, 145


KBCategory: kbdocerr

KBSubcategory:

Additional reference words: 4.00 4.00a



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.