Thanks for the reply.
So I can setup a macro with a hot key combination, and that should suffice,
but I'm still curious as to whether or not there is any way to add a custom
command to a context menu in Excel. Is there any way to do that?
--Tom
"Ron de Bruin" wrote in message
...
Hi Thomas
See this page for code examples
http://www.rondebruin.nl/values.htm
You can add a macro in your personal.xlsb if you want or create a add-in
http://www.rondebruin.nl/personal.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Thomas M." wrote in message
...
Excel 2007
One thing that I do frequently in Excel is convert a range to formulas to
values. The thought hit me today that it would be handy if there was a
Convert to Values option on the context menu so that a person would just
need to highlight the range, right-click, and select the Convert to
Values option. All Excel would need to do is run an automatic copy and
paste special.
Are there any add-ons out there that make this possible? If not, it
there a way for me to add this functionality myself via a custom function
or something?
Thanks for any help that you can offer.
--Tom