Excel Tools menu disabled (2002/XP)

Topic

New Reply

I opened a document from my client that appears to have contained a macro that disabled the

Reply | Quote

Replies

Press Alt+F11 to activate the Visual Basic Editor.
Press Ctrl+G to activate the Immediate window.
Type the following, then press Enter:

Application.CommandBars(“Worksheet Menu Bar”).Controls(“Tools”).Enabled = True

Switch back to Excel.

Note: is your macro security set to Low? That is not recommended. If you set it to Medium, you’ll be prompted whether you want to enable macros.

Reply | Quote

Thank you, Hans. That did the trick.
And security is now set to Medium!

Sarah

Reply | Quote