View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RichardO[_4_] RichardO[_4_] is offline
external usenet poster
 
Posts: 1
Default command button and assign macro

Wow, thanks much for your explanations, Dave:

For your response to #4, are you saying that if I want to disable/hid
and then enable/unhide the button, I should only use the Forms toolba
(and not the controlbox toolbar) and the following code will disabl
and then enable the button later on?

Option Explicit
Sub testme01()
MsgBox "Yo"
With ActiveSheet.Buttons(Application.Caller)
.Enabled = True
'or
.Visible = False
End With
End Sub


Richard

--
Message posted from http://www.ExcelForum.com