disable button in excel spread sheet

[vijay2482]

i have 5 sheets,in one sheet i have 2 buttons.
button 1 - COMPARE
button 2 - CREATE
1)when the spreadsheet is opened,i want the CREATE button to be deactivated/disabled and only COMPARE button should be active.
2)once the COMPARE button is clicked,i want to activate/enable the CREATE button and deactivate/disable the COMPARE button.
how to acquire this?
thank in advance.

 

[Mike Blackman]

Hi Vijay,

Are the CommandButtons?

 

[vijay2482]

yes, its a commandbutton from the excel toolbar and not from the excel userform

is there a way to do this?

 

[Mike Blackman]

Hi,

Right click on the Sheet Tab and select view code;

Pate this in and add in your current macro's;

Private Sub CommandButton1_Click()

CommandButton1.Visible = False
CommandButton2.Visible = True

'Your Code

End Sub

Private Sub CommandButton2_Click()

CommandButton1.Visible = True
CommandButton2.Visible = False

'Your Code

End Sub

 

[Mike Blackman]

Or alternatively;

Private Sub CommandButton1_Click()

CommandButton1.Enabled = False
CommandButton2.Enabled = True

'Your Code

End Sub

Private Sub CommandButton2_Click()

CommandButton1.Enabled = True
CommandButton2.Enabled = False

'Your Code

End Sub

To actually disable and not hide

 

[vijay2482]

i have different macros to COMPARE and CREATE

should i write this code in the macro or in the codeview of the spreadsheet?

 

[Mike Blackman]

You can either add the code from yours into the relevant _Click Maro's for there button's or simply call them by replacing;

' Your Code

With the name or you Macro's.

 

[vijay2482]

thanks for your help.

i tried but not working.....

 

[vijay2482]

sorry,its not a commandbutton
its a button on the excel sheet