I have this excel sheet which has 2 macro buttons GenerateXML and ClearData. The GenerateXML code runs through 6 different sheets to get the expected result. The ClearData code clears the workings done in those 6 sheets by GenerateXML. I want to place the buttons in such a way that only one button is visible and the other is hidden, one on top of other with the help of a code. When I press GenerateXML automatically ClearData must be on the top and vice versa. If the user presses the GenerateXML before ClearData then the code generates an error. To avoid this, I want to try the above way. I have enquired in facebook but I couldn;t get any response. Hope someone will understand and find a solution to the above.