Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Crtl+Z reassigned by muppet - cannot find to fix
hi there
some muppet has reassigned Crtl+Z to a macro and i cannot find where to put it back to 'undo' any ideas? I have been through the 'help' and know how to do it if i knew where it was, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Crtl+Z reassigned by muppet - cannot find to fix
probably help if i put CTRL + Z (i have looked through ALT+8 but there
are no macros attached!!!) some muppet has reassigned Crtl+Z to a macro and i cannot find where to put it back to 'undo' |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Crtl+Z reassigned by muppet - cannot find to fix
First, you do mean ctrl-z (lowercase z, not uppercase, right?)
You could try this: hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter. application.OnKey "^z","" then type this and hit enter: application.OnKey "^z" I'm hoping that the first one turns off the macro assignment and the second one resets it back to normal. If that doesn't work, then I'd start looking for a macro in a workbook that opens when excel opens that steals this assignment. Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp wrote: hi there some muppet has reassigned Crtl+Z to a macro and i cannot find where to put it back to 'undo' any ideas? I have been through the 'help' and know how to do it if i knew where it was, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
Edit + Find | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions |