View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default How to activate the button

Perhaps:

ws.Buttons("Test").Visible = True

--
Jim Rech
Excel MVP
"junx13 " wrote in message
...
| Hi, I have a form button that I managed to hide with this code:
|
| Private Sub Workbook_Open()
| Dim ws As Worksheet
|
| For Each ws In ActiveWorkbook.Worksheets
|
| With ws.Buttons(Application.Caller).Visible = False
| End With
| Next ws
|
|
| End Sub
|
| Now, I dunno how to ref the button I created to make it unhide.
|
| I will be making it appear in the Worksheet_change event.
|
| The button is a form button called Test.
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|