Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel macros(plz hlp)
- Thread starter goofy
- Start date
Don't understand the question, will give several replies:
Can you copy worksheets from different excel workbooks into a single excel workbook? Yes
Can you copy code from different worksheets into a single excel worksheet? Yes
However, some code is dependent on whether it lies in the worksheet, the workbook, or in a module.
If you have several macros you've created and you want them to be available for your use at any time, you'll want to create was is called personal.xls. Instructions are, I believe, in the help files, or reply and I'll get you the instructions you need.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
Can you copy worksheets from different excel workbooks into a single excel workbook? Yes
Can you copy code from different worksheets into a single excel worksheet? Yes
However, some code is dependent on whether it lies in the worksheet, the workbook, or in a module.
If you have several macros you've created and you want them to be available for your use at any time, you'll want to create was is called personal.xls. Instructions are, I believe, in the help files, or reply and I'll get you the instructions you need.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
- Status