Thread: OnClick
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] brett.kaplan@gmail.com is offline
external usenet poster
 
Posts: 48
Default OnClick

Hi,

I have about 15 check boxes on the main sheet in my file. When a box
is checked, I want to add a sheet with a given name:

Sheets.Add.Name = "NAME1

When that box is then unchecked, I want to delete the sheet.

How can I do this through VBA?

Thanks!

Brett