Hello - We have an Excel VBA application that makes heavy use of hyperlinks. Part of the logic of the application's implementation is to store information in the ScreenTip for the hyperlink that essentially contains the SQL WHERE clause for the query to use when calling the database to get the data associated with the link.
What we are seeing is that the application works fine but if there are sheets open that contain certain links when the user closes the workbook, they receive error when reopening it. What have been able to determine is that some of the ScreenTips are longer than 255 characters and that after reloading, they have been truncated to 255. Are you aware of this behavior and there is some setting we can use to get around this limitation ?
-Ken