commands have been grayed out

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?
 
J

john

Hi
Try
Application.CommandBars("Worksheet Menu Bar").Reset

this should set the main menu bar to its original state.
 

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

Cut, Copy, Paste, PasteSpecial grayed out. 9
Edit commands not available 6
menu commands of excel disabled 2
Functions grayed out. Excel 2000 1
Paste into spreadsheet in userform 2
SqlDataSource - CRUD options grayed out 1
can't delete columns 6
Paste-special values disabled 2

Top