How to add the press effect of a button?

**TheOllie** · 10-10-2012, 05:02 AM

Hi All

I have added a shape to my spreadsheet to work as a button. All is fine and it has the desired fumctionality however, I was wondering if anyone would be able to assist me in adding the actual effect or simulate the effect of a button click/pressed?
Any advice on this would be kindly appreciated.

Thanks in advance,

**Kyle123** · 10-10-2012, 05:14 AM

Can't you just use a button?

**Blake 7** · 10-10-2012, 05:19 AM

Edit - sorry Kyle, didnt see your response

Buttons created from controls have the push/press effect. You may have used a shape to which you could add a 3d effect but still wont have the effect you require

**Blake 7** · 10-10-2012, 05:22 AM

See the attached

**TheOllie** · 10-10-2012, 05:40 AM

In theory yes. However, the issue here would be I do not know how to change the shape and the design of the button etc.

**Blake 7** · 10-10-2012, 05:47 AM

You can change the shape/design of a shape on the insert tab but the button formatting has to take place via design mode . right clicking on button and properties

**TheOllie** · 10-10-2012, 05:53 AM

Yeah I have done that however there are no options regarding shape and so I am stuck with a rectangle. Thanks all the same.

**jimmalk** · 10-10-2012, 05:58 AM

Hello Ollie. This is a trick I use for all my buttons. I like the flat buttons, but you can change it if you prefer a different look. If you need further explination how to use it, kindly post back.

button2.xlsm

**TheOllie** · 10-10-2012, 06:08 AM

Hi Jimmalk, thats the kind of effect I am after, so how do I implement that to encorporate the functionality I have already added to my shape?

Thanks,

**jimmalk** · 10-10-2012, 06:14 AM

Ok. First make sure you are in Design Mode. Now, select the button, right click, and select properties. Now in there you can change the font, colors, the title, etc.. Now, in your sheet code you will see the code I put inn there. Look for the place that says '// PUT YOUR CODE HERE And.. put your code there

Also, where you have the 2 SpecialEffect lines, you can change those variables to get a different effect if you like. Like I said earlier, my favorite is the flat effect. ok?

**jimmalk** · 10-10-2012, 06:22 AM

Ollie, one other detail. Select again, right click, and select Format Control. In there are options to make the size an exact size if you want, and you also select the properties if you want the button to stay unmovable (usually recomended). If anything isnt clear, just post. Good luck

**Andy Pope** · 10-10-2012, 06:28 AM

You can play with the 3d formatting of a shape to create fake click.

**TheOllie** · 10-10-2012, 06:37 AM

Oh sorry I was just refering to the click effect. I still want to stick with the shape I have used. I appreciate your help though.

Thanks

**TheOllie** · 10-10-2012, 06:42 AM

Hi Andy, thanks for the suggestion, that is what i have done. Just needed something to show the user the button has registered their action. Was just hoping to add a click looking function. All good though. Thanks everyone.

**Blake 7** · 10-10-2012, 06:45 AM

Nice one andy... saved to my excel sample folder!

**chrisignm** · 06-06-2014, 01:25 PM

Hey, sorry to pick up an old thread.

I tried to do that but can't make it work. I did all the settings like the button of Andy, but when I click on it, nothing changes. What am I doing wrong? I tried it with a rectangle.

**Andy Pope** · 06-07-2014, 05:29 AM

Does the example work for you?

If so post your attempt so we can discover what you did different

How to add the press effect of a button?

LinkBack

Thread Tools

Rate This Thread

Display

How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Re: How to add the press effect of a button?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions