I want a way with code to turn off the "Select Objects" button on the drawing toolbar.
The reason for this is
that I am trying to select a range of cells by finding the last one in the appropriate column, then using a range select to
select everything between there and the start of the sheet:
ActiveWorkbook.Names.Add Name:="BOM_Print_Area", RefersToR1C1:=Selection
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Then I want to assign a Name to this range. However, if the user has the "Select Objects" mode on, the range select
will not work.