-
Solved: Transparent Toggle Button
This is the first time I have ever tried to code anything in VBA so bare with me please. I am trying to create a toggle button in Excel 2003 that is transparent so that you can see the text/formatting in the cell behind it. When you click the button it will hide/unhide specific rows. So far I've been able to get the toggle to do just that except for the transparent part. In the properties window for the toggle I made sure that the backstyle is set to 0 - fmBackStyleTransparent. This makes the button transparent but as soon as I click on it, it turns opaque. Am I missing something? Any and all help would be greatly appreciated.
Here is the code I'm working with for the hide/unhide function:
[vba]Private Sub ToggleButton1_Click()
If ToggleButton1.Value = False Then
Range("a12:a12").EntireRow.Hidden = False
Else
Range("a12:a12").EntireRow.Hidden = True
End If
End Sub[/vba]
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules