If it's working, you've lost the novice label.

"mikewild2000 <" wrote:

Thanks Dave - I got their in the end by copy/paste my code from the
command buttons into seperate macros.

Then using workbook_open()
poped in the onkey statements so that the shortcut keys work.

Not bad for a novice?

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson