Removing macro buttons from part of a sheet
Name the one in col C and remove all except that name
"Tim Childs" wrote in message
om...
Hi
the redoubtable DP (very helpfully) gave me this code to remove all
the buttons from a spreadsheet. In reality I want to restrict the
removal to buttons in Column A only. (there are 100+). Alternatively,
I want to remove all the buttons except for one in Column C. It may
sound odd but it is true!
Please can someone give me a start on revising the code
Thanks
Tim
Set CurWks = ActiveSheet
With CurWks
'Suppressed as it deletes the clear clipboard button
'.buttons.delete
|