ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Regarding to owc (Spreadsheet) Toolbar (https://www.excelbanter.com/excel-programming/317797-regarding-owc-spreadsheet-toolbar.html)

Microsoft News

Regarding to owc (Spreadsheet) Toolbar
 
Hi,
i am customizing toolbar of spreadsheet (owc). I have added custom button on
toolbar.
I have seted tooltip for perticular custom button.
When I calling function to add new custom button to toolbar on
window_onload() procedure.tool tips not appears. if i call trough some input
button its come first and when i click on Speadsheet area it not comes.
I also downloaded some Sample Code from msdn. That also have same problems.

following is my code segment.
Sub AddTips()

Dim tb

Dim btnNewButton

Dim Spreadsheet

Dim iNumButtons


Set Spreadsheet = document.getElementById("Spreadsheet")

Spreadsheet.Refresh

Set tb = Spreadsheet.Toolbar

iNumButtons = tb.Buttons.Count

On Error Resume Next

Set btnNewButton = tb.Buttons.Add(iNumButtons, "cmdCreateView","Creer Vue",
tbrDefault,10)

' Set the tool tip text.

btnNewButton.ToolTipText = "Create view"

iNumButtons = iNumButtons + 1

' Add a separator after the custom button.

tb.Buttons.Add iNumButtons, , , 3

End Sub



Send email to





All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com