View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Memphis Memphis is offline
external usenet poster
 
Posts: 32
Default Removing diagonal lines created on sheet

Thank you Sheelo,
But i do have including the CheckBox many other option buttons created from
the Control Toolbox. i ran a test and it deletes the existing option buttons
and the chkboxE4NA.
I also have grouped many of the option buttons since they are Yes and No
answers.

What to do?

Thanks

"Sheeloo" wrote:

If there is not other shape on the sheets then add similar code to the
uncheck event

For Each shp In ActiveSheet.Shapes
shp.Delete
Next