If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cannot edit macros in excel 2007
Hello,
I made a macro but when I try to edit it I get the message: "cannot edit a macro on a hidden workbook. unhide the workbook using the unhide command" Doing a search I found a page telling me to make a personal.xls file in an XLSTART folder, but it didn't work. I think it is because it was referring to a previous version of Excel. Any help would be appreciated. Thanks. |
#2
|
|||
|
|||
cannot edit macros in excel 2007
If you don't already have a personal.xlsm file then record a macro to
personal and excel will create it for you. -- Don Guillett Microsoft MVP Excel SalesAid Software "ben" wrote in message ... Hello, I made a macro but when I try to edit it I get the message: "cannot edit a macro on a hidden workbook. unhide the workbook using the unhide command" Doing a search I found a page telling me to make a personal.xls file in an XLSTART folder, but it didn't work. I think it is because it was referring to a previous version of Excel. Any help would be appreciated. Thanks. |
#3
|
|||
|
|||
cannot edit macros in excel 2007
Hi Ben
Open the VBA editor with Alt F11 Edit the code in your personal file and click on the Save button in the Editor. Use Alt q to close the editor -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ben" wrote in message ... Hello, I made a macro but when I try to edit it I get the message: "cannot edit a macro on a hidden workbook. unhide the workbook using the unhide command" Doing a search I found a page telling me to make a personal.xls file in an XLSTART folder, but it didn't work. I think it is because it was referring to a previous version of Excel. Any help would be appreciated. Thanks. |
#4
|
|||
|
|||
cannot edit macros in excel 2007
Thanks. It worked.
Ron de Bruin wrote: Hi Ben Open the VBA editor with Alt F11 Edit the code in your personal file and click on the Save button in the Editor. Use Alt q to close the editor |
Thread Tools | |
Display Modes | |
|
|