ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Personal.xls - "Unhide Command" (https://www.excelbanter.com/excel-discussion-misc-queries/83572-personal-xls-unhide-command.html)

Scott Wagner

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

Jmmac04

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


Jim May

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


Scott Wagner

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