I am using the function wclear to automatically clear the contents of several worksheets.
It works beautifully but a long pop-up appears asking confirmation and I have to confirm many times my decision, is there a way to avoid the pop-ups to appear?
The X-Function that is used for the Worksheet : Clear Worksheet menu option is wclear. This function has an option to display the Attention! message or not.
You cannot modify the behavior of the built-in menu, but you could create a Custom menu with an entry that uses the function with the message turned off using this script:
wclear msg:=0;
Select Tools : Custom Menu Organizer On the Add Custom Menu tab, right-click in the gray box and choose "New Main Popup". You can edit the Popup Text. This is what will appear on the Origin menu. Right-click on the added menu and choose "Add Item" Item text could be changed to Clear Worksheet (no prompt) and paste the above script. Uncheck the Graph and Matrix boxes so the menu is disabled when those windows are active. (wclear only works for worksheets) Click Close and respond Yes to save your changes.
When a worksheet is active, you should see a new main menu option with a popup option that clears worksheets without prompting.
bypass pop-up
Posted - 12/05/2012 : 05:23:41 AM
