Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this function which I think that I found here. What I want to do is
make this function global so that it can be used in any workbook or worksheet. So the question is how can I make this happen. Function DocProps(prop As String) Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function TIA GM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
global function | Excel Programming | |||
Making pictures global | Excel Programming | |||
Global Function | Excel Discussion (Misc queries) | |||
Through code : Making a global change to 100 templates | Excel Programming | |||
Autofilter global Show All function disabled in protected worksheet | Excel Programming |