Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation
I have written an excel application and now need to document it.
Is there a quick way to document (print) all the code and all the sheet calculations? Many Thanks Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation
The below is a macro to create a new sheet with the formulas visible
and printable however I've left formatting (resizing of cells and so forth) to you so that it is readable on the printed document. Sub printable() Dim row As Integer Dim col As Integer Dim sheetname As String sheetname = ActiveSheet.Name ActiveWorkbook.Worksheets.Add ActiveSheet.Name = "printable_" & sheetname Worksheets("printable_" & sheetname).Range("A1:IV65536").NumberFormat = "@" For col = 1 To 30 For row = 1 To 30 If Worksheets(sheetname).Cells(col, row).Formula = "" Then Worksheets("printable_" & sheetname).Cells(col, row) = Worksheets(sheetname).Cells(col, row).Value Else Worksheets("printable_" & sheetname).Cells(col, row) = Worksheets(sheetname).Cells(col, row).Formula End If Next row Next col End Sub Hope this helps |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation
test
"paul johnson" wrote in message ... I have written an excel application and now need to document it. Is there a quick way to document (print) all the code and all the sheet calculations? Many Thanks Paul |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation
Paul,
Printing the code from the VBA IDE should not be a problem. As for the sheets, you mean formulae ? Go to Options and select "Formuals", then print. NickHK "paul johnson" wrote in message ... I have written an excel application and now need to document it. Is there a quick way to document (print) all the code and all the sheet calculations? Many Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where's the Documentation for the APIs? | Excel Programming | |||
WorksheetFunction Documentation | Excel Worksheet Functions | |||
Look up VBA documentation using Excel Help | Excel Programming | |||
VBA Documentation | Excel Programming | |||
Documentation | Excel Programming |