Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Clearing Contents

Posted by Jessica Garcia on July 19, 2001 10:42 AM

I once saw a worksheet that had a shaded bar at the end that said "clear". When you pressed this button it cleared certain portions of the worksheet out. Does anyone know how this is done?

Re: Clearing Contents

Posted by Mark W. on July 19, 2001 10:51 AM

That would be the "Clear Contents" toolbar which
you can add using the View | Toolbars | Customize...
menu command. Look in the Edit Commands list. Drag
it to your existing toolbar.

Re: Clearing Contents

Posted by Scott S on July 19, 2001 10:53 AM

Most likely, this was a button that executed a macro. If you would like to do this, and need instructions, let me know.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.