Sebastian

In addition to storing in the Personal.xls workbook, make sure the code does
not refer to hard-coded items such as worksheet names, workbook names, cell
references etc.

Use relative references as Offset, Activecell, Activesheet.

If recording the macros, toggle the "Relative Reference" button to "ON"

Gord Dibben Excel MVP

On Tue, 10 Feb 2004 05:01:38 -0600, Sebastian_var
wrote:

Hi,
I need to create a macro which could be used for all excel sheets.
Is this possible.
Thanks...


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