i have a sheet with 260 macro buttons on it. the buttons are either "Add" or "Del" and basically the add button creates the sheet and populates it with some data, the Del deletes the sheet. the color of the Add button is green and the Del button is red. what i would like to do is have some code that greys out the Add button if the sheet does exist and greys out the Del button if the sheet doesnt exist. i have no code to work with as i dont even know how to program the buttons for this functionality. so is this possible to do?
here is the Add button for Sheet A
here is the Del button for Sheet APlease Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks