When I try to edit a macro that has been stored in personal.xls, it tells me
to unhide the workbook first, then I will be able to edit the macro, however
I can not figure out how to do this. Any suggestions? Thanks

You can unhide a hidden workbook using Window;unhide. Another way to get to
your personal.xls macros is to click Alt+F11, which will open up the VB
Editor.

"excelchallenged" wrote:

When I try to edit a macro that has been stored in personal.xls, it tells me
to unhide the workbook first, then I will be able to edit the macro, however
I can not figure out how to do this. Any suggestions? Thanks

windowsunhide

--
Don Guillett
SalesAid Software

"excelchallenged" wrote in
message ...
When I try to edit a macro that has been stored in personal.xls, it tells
me
to unhide the workbook first, then I will be able to edit the macro,
however
I can not figure out how to do this. Any suggestions? Thanks

Go to the Window menu to Unhide, then you will be able to edit the macro in
the personal.xls file.

Andrew

"excelchallenged" wrote:

When I try to edit a macro that has been stored in personal.xls, it tells me
to unhide the workbook first, then I will be able to edit the macro, however
I can not figure out how to do this. Any suggestions? Thanks

Thanks all, but my unhide button is greyed out so I can't open it. I can get
to the VB editor but once there, can I insert new actions using a 'start
recording' button or must I enter the commands manually?

"Don Guillett" wrote:

windowsunhide

--
Don Guillett
SalesAid Software

"excelchallenged" wrote in
message ...
When I try to edit a macro that has been stored in personal.xls, it tells
me
to unhide the workbook first, then I will be able to edit the macro,
however
I can not figure out how to do this. Any suggestions? Thanks

In VBE you must enter commands manually.

"excelchallenged" wrote:

Thanks all, but my unhide button is greyed out so I can't open it. I can get
to the VB editor but once there, can I insert new actions using a 'start
recording' button or must I enter the commands manually?

"Don Guillett" wrote:

windowsunhide

--
Don Guillett
SalesAid Software

"excelchallenged" wrote in
message ...
When I try to edit a macro that has been stored in personal.xls, it tells
me
to unhide the workbook first, then I will be able to edit the macro,
however
I can not figure out how to do this. Any suggestions? Thanks

You may record a macro and select the personal.xls to save it to. Look at
your options.
toolsmacrorecordstore macro inselect personal.xlswhen closing you will
be asked to save.

--
Don Guillett
SalesAid Software

"excelchallenged" wrote in
message ...
Thanks all, but my unhide button is greyed out so I can't open it. I can
get
to the VB editor but once there, can I insert new actions using a 'start
recording' button or must I enter the commands manually?

"Don Guillett" wrote:

windowsunhide

--
Don Guillett
SalesAid Software

"excelchallenged" wrote in
message ...
When I try to edit a macro that has been stored in personal.xls, it
tells
me
to unhide the workbook first, then I will be able to edit the macro,
however
I can not figure out how to do this. Any suggestions? Thanks