=CLOSE() Returns a Macro Error on Protected Worksheet
ID: Q66760
|
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 :
|