| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear Button
Hi JudyP, See how you get on with recording a macro Tools Macro Record new macro Macro1 Select store in this workbook, then OK Click the cells you want to clear, then press the Delete key Stop marco recording Now - View Toolbars Forms Click on the "button" icon and draw one on your spreadsheet (Button 1, you can change this to "Clear"), the Assign macro box opens – select Macro1 OK Is this any help? oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=568664 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Button or key to conditionally change text foreground color? | New Users to Excel | |||
| Command Button Assignment | Excel Discussion (Misc queries) | |||
| Creating button as cell | Excel Discussion (Misc queries) | |||
| Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
| How do I insert a 'clear all' button in excel? | Excel Worksheet Functions | |||
Hybrid Mode
