I'm planning to write a large program in Excel. I wish to use a sub-routine that will be used in many of the different worksheets. Is there any way of accessing the same sub routine from many different worksheets, thus saving a lot of extra code?
Reading your post, i get the impression you are talking about creating a worksheet formula (i.e. a formula in a cell). You then want to use that formula in another place in the workbook without having to retype it.
Thank you. How do I set up say a subroutine, to ask a persons name using a button in sheet 1 and sheet2. How do a write/label a subroutine in a generel module to access from any worksheet. Many thanks for your help.