ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Personal.xls macro folder stopped working (https://www.excelbanter.com/excel-programming/374251-personal-xls-macro-folder-stopped-working.html)

[email protected][_2_]

Personal.xls macro folder stopped working
 
Hi Guys

Two things

1) My personal .xls macro folder has stopped working (something about
unhiding worksheets??)

2) can I write a macro at home, take it to work and attach it to a
spreadsheet there, and if so how?

Much Appreciated

Brian


Jim May

Personal.xls macro folder stopped working
 
1) The file personal.xls should be located in the XLstart folder under
your Excel Office folder (under programs).

2) If you have a macro written (already) in Test.xls (say) - Mail it as
an
Attachment from your home to your office.. At your office -

Open or create the your Destination file and Alt+F11 to get to the VBE
environment - Click (at the menu) Insert, Module where you code window
is blank, then -- Open your Text.xls file Alt+F11 (to get to the VBE)
and the code window showing your macro code. Highlight it, and Copy it;
Then switch to your Destination file's Module - Code window and do a
Paste;
Your code is now in the destination VBE.

Rather easy, I do it all the time.......
HTH



" wrote in
message oups.com:

Hi Guys

Two things

1) My personal .xls macro folder has stopped working (something about
unhiding worksheets??)

2) can I write a macro at home, take it to work and attach it to a
spreadsheet there, and if so how?

Much Appreciated

Brian




All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com