Posted to microsoft.public.excel.programming

KS[_2_]

external usenet poster

Posts: 5

Rewrite cut action not working.

Why isn't this working? I get an "object variable or with block not
set" error.

Sub MyCopy()
'rewrite Ctrl-X
Selection.Copy
MsgBox "Please copy [Ctrl-C] rather than cut."
End Sub

Sub mycut()
ActiveWorkbook.CommandBars("Standard").Controls("C ut").OnAction =
"MyCopy"
ActiveWorkbook.CommandBars("Cell").Controls("cut") .OnAction =
"MyCopy"

End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excell copy action pauses for 15 second for the smallest action	Meekal	Excel Discussion (Misc queries)	1	January 28th 10 04:30 PM
rewrite in range	ina	Excel Programming	2	May 16th 06 03:07 PM
How can I rewrite this using an Array?	Fred[_21_]	Excel Programming	7	September 13th 05 05:45 PM
Custom Toolbar: ListBox on.action not working	Alison[_3_]	Excel Programming	3	August 11th 04 04:30 AM

All times are GMT +1. The time now is 02:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us