View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Perrier Shaw Perrier Shaw is offline
external usenet poster
 
Posts: 1
Default Control tip text

Hi,

I'd like to add control tip text to command buttons on a
worksheet.

I've tried to include the code :

Sub Workbook_open()
Sheets("test").commandbutton1.controltiptext="text "
End Sub

But it does not work.

How to do it?
Many thanks.