ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disabling "Entire &row/&column" in Delete/Insert Cell (https://www.excelbanter.com/excel-programming/324681-disabling-entire-row-column-delete-insert-cell.html)

Gap

Disabling "Entire &row/&column" in Delete/Insert Cell
 
Hello,

When right clicking on a Cell and selecting "Insert..." or "Delete..."
there are 4 options (radio buttons) displayed.
Is there a way to disable the last 2 radio buttons i.e. "Entire &row"
and "Entire &column" in VBA?

Thank you.
Gap


Bob Phillips[_6_]

Disabling "Entire &row/&column" in Delete/Insert Cell
 
I think you would need to create your own limited form, and re-assign the
Delete control on the Cell menu.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gap" wrote in message
oups.com...
Hello,

When right clicking on a Cell and selecting "Insert..." or "Delete..."
there are 4 options (radio buttons) displayed.
Is there a way to disable the last 2 radio buttons i.e. "Entire &row"
and "Entire &column" in VBA?

Thank you.
Gap





All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com