Enable / Disable Shapes

[nianchi111]

Hi All,

I have a excel template where I have 8 shapes created as button and assigned a macro to each shape.

Is there a option to disable the Shapes where the users are unable to click the shapes to run the macro.

For example:

I have a shapes with names Login and Logout.

When the excel is opened i want Only the Login is enabled where the user is allowed only to click the Login button and once the Login is clicked i want this to be disabled and enable the Logout Shape is active. this will prevent the user from clicking the Login shape which they have already selected. So they are left with option to click only the Logout shape.

Thanks in advance.

Regards,
Vimal Vikraman.

 

[jasonb75]

The simple way would be to declare a public variable as Boolean, set it to True with the login code and False with the logout code.
Then add a line to the code for Login to exit the sub if the variable is True, do the same for Logout if the varaible is False.

You could use the variable to set the shapes visible / hidden instead of disabling them. Setting the default for each button in a workbook open event. *Note that this will not work with a shared workbook*