Hi,

You can copy the code provided to a code module.
Open a workbook, press "Alt" and "F11" this should take you to the
Project.
In the "Tool" bar select "Insert", then select "Module". Now you can
copy the code provided to this module.
While still in the code module you can run the code from there. However
you will need too provide a "ShortCut" key other wise you will need to
run the code from the module.
Not knowing which version of "Excel" you are using, you can in 2007,
select "Developer" then select "Macro" and with the popup select
"Options" and now you can set the Shortcut key. Click Ok and you done.
Now save the workbook and you can use the shortcut key to run the
program.

I hope this helps.

Charles


--
CharlesH
------------------------------------------------------------------------
CharlesH's Profile: http://www.thecodecage.com/forumz/member.php?u=1354
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=175527

http://www.thecodecage.com/forumz


--- news://freenews.netfront.net/ - complaints: ---