Lost "Undo" Function

bomalley · Feb 20th, 2002, 02:35 PM

Hi there,

I seem to have lost the ability to undo things in Excel, not sure why, option is greyed out.

Anyone have any answers?

Cheers,
Brandon

JohnG · Feb 20th, 2002, 02:38 PM

do you have the workbook or sheet protected?

Quote:

On 2002-02-20 13:35, bomalley wrote:
Hi there,

I seem to have lost the ability to undo things in Excel, not sure why, option is greyed out.

Anyone have any answers?

Cheers,
Brandon

bomalley · Feb 20th, 2002, 02:42 PM

No, not protected. Although when I first open Excel, it pops up telling me that the workbook I'm opening is protected, even though it's just the default workbook.
Only had this problem since playing with macros.

Jack in the UK · Feb 20th, 2002, 06:15 PM

Hi

Just a quess, check the sheets not moduels poss targetrabge code is live if so only two lines of code ending

end sub on second line delete all of it, it an error you or someone put in by mistake. This will stop it if its there.

If not chect the modules for som off two lines of code..

HTH
Rdgs
==========
Jack

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 02:35 PM	#1
bomalley New Member Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 21	Hi there, I seem to have lost the ability to undo things in Excel, not sure why, option is greyed out. Anyone have any answers? Cheers, Brandon

Feb 20th, 2002, 02:42 PM	#3
bomalley New Member Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 21	No, not protected. Although when I first open Excel, it pops up telling me that the workbook I'm opening is protected, even though it's just the default workbook. Only had this problem since playing with macros.

Feb 20th, 2002, 06:15 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Just a quess, check the sheets not moduels poss targetrabge code is live if so only two lines of code ending end sub on second line delete all of it, it an error you or someone put in by mistake. This will stop it if its there. If not chect the modules for som off two lines of code.. HTH Rdgs ========== Jack