![]() |
Personal.xls - "Unhide Command"
I'm trying to edit a macro, and add some others, to my personal.xls workbook.
I realize it is a hidden workbook, based on what I have read in these boards, but I am having a problem "unhiding" it. I did a search for "personal.xls" and selected the option to "show hidden files". It comes up just fine, and is in the XLStart folder as expected. I right click on the file and choose properties, and "hidden" is not checked. The message that comes up when I try to edit the macro in this workbook says, "Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command." What am I missing? Thanks, Scott |
Personal.xls - "Unhide Command"
Hi Scott~
Open excel go to the windows menu unhide click "personal.xls" click OK "Scott Wagner" wrote: I'm trying to edit a macro, and add some others, to my personal.xls workbook. I realize it is a hidden workbook, based on what I have read in these boards, but I am having a problem "unhiding" it. I did a search for "personal.xls" and selected the option to "show hidden files". It comes up just fine, and is in the XLStart folder as expected. I right click on the file and choose properties, and "hidden" is not checked. The message that comes up when I try to edit the macro in this workbook says, "Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command." What am I missing? Thanks, Scott |
Personal.xls - "Unhide Command"
Scott:
From within Excel - click on the Menu, Window; from the drop-down, select Unhide; select Personal - OK. There from the initial spreadsheet - ALT+F11 You're now in... Jim May "Scott Wagner" wrote: I'm trying to edit a macro, and add some others, to my personal.xls workbook. I realize it is a hidden workbook, based on what I have read in these boards, but I am having a problem "unhiding" it. I did a search for "personal.xls" and selected the option to "show hidden files". It comes up just fine, and is in the XLStart folder as expected. I right click on the file and choose properties, and "hidden" is not checked. The message that comes up when I try to edit the macro in this workbook says, "Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command." What am I missing? Thanks, Scott |
Personal.xls - "Unhide Command"
Thanks!
|
All times are GMT +1. The time now is 02:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com