Hi,
I would like to copy 1 sheet to all excel files that will be open at the time.
If anyone has a macro for this will b egreat as there are quite a few files that need to be done and a very short time frame.
Hi,
I would like to copy 1 sheet to all excel files that will be open at the time.
If anyone has a macro for this will b egreat as there are quite a few files that need to be done and a very short time frame.
Hello Adnan Fetai,
Welcome to the Forum!
Here is macro to copy the first Sheet of the workbook into every other open workbook.
![]()
Please Login or Register to view this content.
Adding the Macro
- Copy the macro above pressing the keys CTRL+C
- Open your workbook
- Press the keys ALT+F11 to open the Visual Basic Editor
- Press the keys ALT+I to activate the Insert menu
- Press M to insert a Standard Module
- Paste the code by pressing the keys CTRL+V
- Make any custom changes to the macro if needed at this time.
- Save the Macro by pressing the keys CTRL+S
- Press the keys ALT+Q to exit the Editor, and return to Excel.
To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you that works perfectly. I neesd to do a VBA course to be able to write these macros.
Again thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks