Sorry! This reply was meant to another thread at all :-((
"Arvi Laanemets" wrote in message
...
Hi

Instead of workbooks module, save the code in Personal Macro Workbook
(Personal.xls) module.

When you don't have Personal.xls jet, then easier way to create it at
right
place is to record a macro to it (ToolsMacroRecord New Macro, select
'Store macro in' = 'Personal Macro Workbook' and press OK. Stop recordig.)
Now press Alt+F11, in VBA Project window activate the module of
Personal.xls, delete the lately created dummy macro, and copy the UDF code
into this module. From now on, this UDF is avaiable for all workbooks
opened
in this computer.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"KHashmi316"
wrote
in message ...

Arvi Laanemets Wrote:


PasteSpecialValues


Hi, Avi:

Can this be set *globally* somehow (i.e. for all Excel projects)? I
didn't see an option in ToolsOptionsEdit.


--
KHashmi316


------------------------------------------------------------------------
KHashmi316's Profile:
http://www.excelforum.com/member.php...o&userid=10439
View this thread:
http://www.excelforum.com/showthread...hreadid=504298