Microsoft KB Archive/66760

{|
 * width="100%"|

=CLOSE Returns a Macro Error on Protected Worksheet

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0

-

SUMMARY
When the =CLOSE command is used in a macro that closes a protected worksheet, Microsoft Excel produces a macro error.

This only happens when the worksheet has window protection, whether the =CLOSE command parameter is true, false, or none. This occurs because the =CLOSE command is the same command that is available on the worksheet's control menu. A macro error is produced because there is no control menu on a window-protected worksheet.

(Note: this is also true for version 5.0 macro sheets, but not modules.)

Solution
To correct the problem, use =FILE.CLOSE. This command is available on any worksheet, whether it is protected or not.

Additional query words: 2.0 2.00 2.01 2.1 2.10 3.0 4.0 5.0

Keywords :

Version :

Platform :

Issue type :

Technology :