-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Form buttons with color
- Thread starter Praxis
- Start date
Fryer Tuck
Board Regular
- Joined
- Mar 20, 2002
- Messages
- 64
Yes.
First off, make them command buttons instead. (You will have to find these in the Control Toolbox). Then on the sheet or worksheet macro page, put the action to be taken when you click on it.
As for the coloring, go to the macro page and specify Draft Mode, then to the spreadsheet and highlight the button, then to the macro page and open the properties box and color to your hearts content.
F.T.
First off, make them command buttons instead. (You will have to find these in the Control Toolbox). Then on the sheet or worksheet macro page, put the action to be taken when you click on it.
As for the coloring, go to the macro page and specify Draft Mode, then to the spreadsheet and highlight the button, then to the macro page and open the properties box and color to your hearts content.
F.T.
Upvote
0
Jack in the UK
Well-known Member
- Joined
- Feb 16, 2002
- Messages
- 3,215
I would like to dedicate this post to Terry "MANHATTON" Hatton Res1cue New York
Remember rather that using the normal forms tool bar, which Jack say in Terry Hattons words is TOTALLY UN EXCEPTABLE, try any image, text box, JPG, whatever build your own in drawing toolbars
ITS fun and different and link the scripted code to that image.
I use alsorts of images and boxes and all forts, its such fun.
On a down sad note
as late i have a JPG of Terry Hatton and many EMS crews from the World Trade Center desister.
Proves a point Terry Captin of Rescue 1 the link is in the lounge, was to days report.
Different a guys face in resuce gear!! but my work was second to him.
I have gifs of fire lines and so on i add as graphics, its RESPECT!!
Remember rather that using the normal forms tool bar, which Jack say in Terry Hattons words is TOTALLY UN EXCEPTABLE, try any image, text box, JPG, whatever build your own in drawing toolbars
ITS fun and different and link the scripted code to that image.
I use alsorts of images and boxes and all forts, its such fun.
On a down sad note
as late i have a JPG of Terry Hatton and many EMS crews from the World Trade Center desister.Proves a point Terry Captin of Rescue 1 the link is in the lounge, was to days report.
Different a guys face in resuce gear!! but my work was second to him.
I have gifs of fire lines and so on i add as graphics, its RESPECT!!
Upvote
0
