Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default

For one particular cell?

I'd just copy|paste into notepad and print from there.

Debra Dalgleish/JE McGimpsey have a data|validation documenter available at:

http://www.contextures.com/xlDataVal09.html

And Debra has a way to extract comments an put them into a word document at:
http://www.contextures.com/xlcomments03.html#CopyToWord

And for hyperlinks, you could do something like:

Option Explicit
Sub DataValDocumenter()

Dim myHyperLink As Hyperlink
Dim FileNum As Long

If ActiveSheet.Hyperlinks.Count = 0 Then
MsgBox "No hyperlinks"
Exit Sub
End If

FileNum = FreeFile
Open "hyperlinks.txt" For Output As #FileNum
For Each myHyperLink In ActiveSheet.Hyperlinks
Print #FileNum, myHyperLink.Parent.Address(False, False) & vbTab _
& myHyperLink.Address & vbTab & myHyperLink.SubAddress & vbTab _
& myHyperLink.Parent.Text

Next myHyperLink
Close #FileNum

End Sub

If you're really industrious, you could even combine them into one giant
routine!



Ray de Laune wrote:

we want to be able to print the comments and or hyperlinks, connected to a
particular cell and the data validation information.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"