Have you tried rewritting the macro in Personal.xls to show the sheet? I
recently encountered a similar situation where I had to rewrite a Call event
in the original spreadsheet to change the property .onaction = "Name of
Procedure" to .onaction = "" . This worked for me, but as a warning I have
limited VB programming skills (self taught/trial and errror!).

"jk" wrote:

I created a macro to hide a sheet and by mistake applied it to all
workbooks-----Result---Any new workbook opens as a Personal.xls and only
contains one sheet even though the general options is set to open on 3
sheets.How can i undo my macro error?