Turn off table title

Turn off table title

S7RM7RPR
Advocate Advocate
615 Views
4 Replies
Message 1 of 5

Turn off table title

S7RM7RPR
Advocate
Advocate

Can anyone tell me how to turn off a custom table title? API help says to use the code below but I can't figure out how to bloody use it. Yes I'm frustrated lol. API help is a joke nothing works properly.

 

CustomTable.title() as boolean
0 Likes
Accepted solutions (1)
616 Views
4 Replies
Replies (4)
Message 2 of 5

rossano_praderi
Collaborator
Collaborator

Hi, which API help are you reading?

 

' CustomTable.ShowTitle() as boolean
' CustomTable.Title() as string CustomTable.ShowTitle = False ' turned off CustomTable.ShowTitle = True ' turned on

 Let me know is this work for you ( i didn't tested).

 

Bregs

Rossano Praderi



--------------------------------------
If my post answers your question, please click the "Accept as Solution"
button. This helps everyone find answers more quickly!
---------------
0 Likes
Message 3 of 5

bretrick30
Advocate
Advocate

This will turn off the title for the first placed table on the Active Sheet.  

 

SyntaxEditor Code Snippet

ThisDoc.Document.ActiveSheet.CustomTables.Item(1).Style.ShowTitle = False
0 Likes
Message 4 of 5

rossano_praderi
Collaborator
Collaborator

This example will turn off the titles for all the custom tables on the ActiveSheet.

 

' First solution hide all customtable titles
' For Each ... Next
Dim cust As customtable
For Each cust In ThisDoc.Document.ActiveSheet.CustomTables
	'cust.Style.ShowTitle = False
	cust.ShowTitle = False
Next
MsgBox("")
' Second solution unhide all customtable titles
' FOR index TO value NEXT
For i=1 To ThisDoc.Document.ActiveSheet.CustomTables.count
	'ThisDoc.Document.ActiveSheet.CustomTables.Item(i).Style.ShowTitle = True
	ThisDoc.Document.ActiveSheet.CustomTables.Item(i).ShowTitle = True
Next

 

Bregs

Rossano Praderi



--------------------------------------
If my post answers your question, please click the "Accept as Solution"
button. This helps everyone find answers more quickly!
---------------
0 Likes
Message 5 of 5

S7RM7RPR
Advocate
Advocate
Accepted solution

Thank you for the suggestions. I actually have multiple tables but I only need to turn the title off for a specific table. This is what I've used.

 

I'm marking this as my solution to my particular problem but make sure to read the rest of the posts if you want to do it for multiple custom tables.

 

ThisDoc.Document.ActiveSheet.CustomTables.Item(4).ShowTitle = False
0 Likes