Thomas K. Posted August 18, 2023 Share Posted August 18, 2023 Hi is it possible to close 10 (or more or less) worksheet without clicking 10times on this tiny X-button? Why I am asking: when publishing my plots, sometimes there are some worksheets that hide on the second screen. When they are still open there is only an X showing in my pdf files. Thanks for help. Quote Link to comment
Pat Stanford Posted August 18, 2023 Share Posted August 18, 2023 The following script should do what you want. Test before using. Very lightly tested. Procedure CloseAllWorksheets; VAR H1:Handle; Begin H1:=GetTopVisibleWS; While H1<>Nil DO BEGIN ShowWS(H1, False); H1:=GetTopVisibleWS; End; End; Run(CloseAllWorksheets); Quote Link to comment
Thomas K. Posted August 19, 2023 Author Share Posted August 19, 2023 @Pat Stanford: thank you very much for sharing your knowledge. As always! Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.