Macro error message - Hidden worksheet

[audiate]

Hi there,
I'm using Excel 2007, and I can create macros using the Record Macro button, but if I later try to edit the macro, I get the error message:
"Cannot edit a macro in a hidden workbook. Unhide the workbook using the Unhide Command"

I have no idea WHERE I'm supposed to unhide a workbook.

I once before managed to unhide the personal.xlsb workbook (if only I could remember how!), but then I had the problem that it would always open (in its own window) every time I opened Excel.

Is there some way to stop this from happening altogether? I never had this problem in Excel 2003!

thanks.

 

[JLGWhiz]

Hi there,
I'm using Excel 2007, and I can create macros using the Record Macro button, but if I later try to edit the macro, I get the error message:
"Cannot edit a macro in a hidden workbook. Unhide the workbook using the Unhide Command"

I have no idea WHERE I'm supposed to unhide a workbook.

I once before managed to unhide the personal.xlsb workbook (if only I could remember how!), but then I had the problem that it would always open (in its own window) every time I opened Excel.

Is there some way to stop this from happening altogether? I never had this problem in Excel 2003!

thanks.

This courtesy of Lieth Ross, Excel Forum Moderator:

These macros are probably in your Personal.xlsb workbook. This workbook is hidden when you open a standard workbook. You can locate this workbook in the following directory: C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART

 

[shg]

In the VBE, look in the Project Explorer window, locate Personal, and expand the project to see the modules.

If you wanted to unhide Personal (but there's no need), click Unhide on the View tab.

 

[Graeme155]

In the VBE, look in the Project Explorer window, locate Personal, and expand the project to see the modules.

If you wanted to unhide Personal (but there's no need), click Unhide on the View tab.

Sorry I have trouble following this. Under View Tab in the Personal there is no <Unhide> button. I'm using windows 2010.

 

[Graeme155]

No unhide bitton

 

[druhaj]

No unhide bitton

[FONT=&quot]On the [/FONT][FONT=wf_segoe-ui_semibold]View[/FONT][FONT=&quot] tab, in the [/FONT][FONT=wf_segoe-ui_semibold]Window[/FONT][FONT=&quot] group, click [/FONT][FONT=wf_segoe-ui_semibold]Unhide[/FONT][FONT=&quot].
[/FONT][FONT=&quot]In the [/FONT][FONT=wf_segoe-ui_semibold]Unhide[/FONT][FONT=&quot] dialog box, you should see [/FONT][FONT=wf_segoe-ui_semibold]PERSONAL.XLSB[/FONT][FONT=&quot].
[/FONT][FONT=&quot]Click [/FONT][FONT=wf_segoe-ui_semibold]OK[/FONT][FONT=&quot] to view the personal workbook.[/FONT]
[FONT=&quot]Any macros you save to the personal workbook can be edited only by first unhiding the personal workbook. This prevents you from accidentally deleting or making unwanted changes to those macros.[/FONT]

 

[MARK858]

Any macros you save to the personal workbook can be edited only by first unhiding the personal workbook.

You can edit macro's in the Personal workbook via the Project Explorer without unhiding the Personal Workbook. Just expand it to show the modules than double click the module or right click the module and click View Code.