Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula not being called from personal.xls | Excel Discussion (Misc queries) | |||
problem from Personal.xls | Setting up and Configuration of Excel | |||
Hiding Personal.xls Requires Exit Twice | Excel Worksheet Functions | |||
Personal.xls | Excel Discussion (Misc queries) | |||
Personal.xls and Excel.xlb | Excel Discussion (Misc queries) |