commands have been grayed out

  • Thread starter Thread starter Greg Z
  • Start date Start date
G

Greg Z

Opened excel files and certain commands are grayed out...i.e. cut,copy,
paste, delete. thought permissions had been turned on but still reads
unrestricted. Any ideas?
 
Hi
Try
Application.CommandBars("Worksheet Menu Bar").Reset

this should set the main menu bar to its original state.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Functions grayed out. Excel 2000 1
Unable to Delete Sheets or see Properties 3
Cut, Copy, Paste, PasteSpecial grayed out. 9
Edit commands not available 6
menu commands of excel disabled 2
Urgent: Enable All of the excel command bar 1
Protect workbook for Windows option is grayed out in Excel 2013 3
change the command button backcolor in Excel 2007? 2

Back
Top