On May 22, 10:17 am, Tom Ogilvy
wrote:
when you paste, do

activecell.pastespecial xlValues

look in Excel VBA help at the Shell command.

--
Regards,
Tom Ogilvy



"Kapi187" wrote:
I hope someone can help me... I'm trying to create a worksheet in
excel where the user inputs a number and a result shows in the
following cell. I want to create a button where when they click on it
the button copies the result into the clipboard and at the same time
launches an external program. I got the button to copy the cell but
it's copying the formula from the cell not the results. And i'm not
sure where to start with having it launch an application... any help
is appreciated.- Hide quoted text -

- Show quoted text -

Thanks... i have another question. I want to export this to a webpage
but when i do the button that i have on the sheet doesn't show up. I
tried exporting with interactivity but still no button. Any ideas?