Editing Macros

[ManhattanRebel]

When I try to edit a Macro, I'm getting an eroor message that states that I
need to unhide the workbook. How can I unhide a workbook.

Thank you

 

[FSt1]

hi
to answer your question..
on the menu bar..
window>unhide>select file from dialog>ok

but you really don't need to unhide the file if you edit direct through the
vb editor.
Alt+F11.

regards
FSt1

 

[Gord Dibben]

Window>Unhide is the general method.

Is the macro in your Personal.xls workbook?

Is Personal.xls disabled under Help>About MS Excel>Disabled items?

If so, try to enable it.


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

If you use Excel 2007

Excel 97-2003: Window>UnHide
Excel 2007 : On the View tab in the window group choose UnHide

After you edit the code hide it again
Then close Excel and say Yes to save the changes to your PERSONAL file.


When Excel think the file is corrupt it can disable the file.
You can re-enable it here but if it is really corrupted replace it with a backup.

Excel 2002-2003: Help>About MS Excel>Disabled items
Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go

 

[ManhattanRebel]

Thank you ..That is exactly what I needed to do.

If you use Excel 2007

Excel 97-2003: Window>UnHide
Excel 2007 : On the View tab in the window group choose UnHide

After you edit the code hide it again
Then close Excel and say Yes to save the changes to your PERSONAL file.


When Excel think the file is corrupt it can disable the file.
You can re-enable it here but if it is really corrupted replace it with a backup.

Excel 2002-2003: Help>About MS Excel>Disabled items
Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go

 

[Alan]

Thank you ..That is exactly what I needed to do.










- Show quoted text -

Hi,

If the excel file is really corrupt, you may try Advanced Excel Repair
at http://www.datanumen.com/aer/ This tool is rather useful in
salvaging damaged Excel xls files.