ExcelBanter - commands have been grayed out

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - commands have been grayed out (https://www.excelbanter.com/excel-programming/402296-commands-have-been-grayed-out.html)

Greg Z

commands have been grayed out

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?

John

commands have been grayed out

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

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

"Greg Z" wrote:

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?

All times are GMT +1. The time now is 08:25 AM.