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?

delete the macro out of your personnnal.xls


"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?

That is a problem as well since i already deleted the macro within the
workbook i was working with.I have looked into the workbooks i have and none
contain the macro.Yet as i have stated before, on every new workbook open,
it opens as a personal xls.Each existing workbook opens as a personal xls but
reverts to its orginal format of 7 or 8 sheets.How do i get this macro out?

"Rich" wrote:

delete the macro out of your personnnal.xls


"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?

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?

As a clarification on my reply...before I changed the call even to .onaction
= "", I had to fix the macro in the original call event. In my case I had to
emulate the "delete" control. In your case as I indicated, you will likely
need to show the sheet.

"Virtual Hillbilly" wrote:

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?

Hi,

I am new to this and i see that the orginal where i created and deleted the
macro workook opens with a personal workbook containing one sheet.I looked
uder tools ..macro but of course it does not show since i deleted it.What
else can i do to remove this?


"Virtual Hillbilly" wrote:

As a clarification on my reply...before I changed the call even to .onaction
= "", I had to fix the macro in the original call event. In my case I had to
emulate the "delete" control. In your case as I indicated, you will likely
need to show the sheet.

"Virtual Hillbilly" wrote:

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?

You can try running the following macro in Personal.xls:

SheetsInNewWorkbook = 3

Not sure if that will work, but its worth trying!



"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?