| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable clear all using VBA
I have tried several versions of the following code and have been
unsuccessful on disabling the "clear all" feature in version 2003 and 2007. Any suggestions? Sub testclear() Application.CommandBars("edit").Controls("Clear"). Enabled = False End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
| XL2002 - Disable 'clear all' when protected | Excel Discussion (Misc queries) | |||
| Create a Clear button to clear unprotected cells | Excel Programming | |||
| clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
| Clear all? | Excel Discussion (Misc queries) | |||
Threaded Mode
