Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet macro stopped working! | Excel Discussion (Misc queries) | |||
Macro stopped working | Excel Discussion (Misc queries) | |||
macro stopped working after upgrade to 2007 | Excel Discussion (Misc queries) | |||
personal macro workbook just stopped loading | Excel Discussion (Misc queries) | |||
why did the macro stopped working? | Excel Programming |