P
PCLIVE
Gord,
Thanks for the info. I have Excel setup to ask me about enabling and
disabling macros when opening a worksheet. I've tried both with no luck. I
get the same error when attempting to open this file.
The workbook that I'm opening has always worked before. That workbook and
macros were designed and written by me and they have been working for more
that 5 months now. There are only two worksheets in the workbook and I've
never had any reason to group them together, however, when the workbook
opens with the error, I can see that the two sheets are, in fact, selected.
In addition, a third sheet is now showing, which is labeled "Module1".
Since I can't navigate through the workbook because of the error, I do not
know what is on this sheet.
It is apparent that the workbook is at least opening partially. If I could
just find a way to get the macro text out without having to fully open the
file, then I'd be ok.
I don't recall having any kind of Auto_Open macro. However, I have tried
disabling macros upon opening the file. I've tried the Shift key while
opening, but it still prompts me about the macros to which I choose to
disable. I attempted the command with the " /safe", but that results in a
file not found. I'm using Excel 2000 on a Win2000 computer. I've also
tried a Windows Me computer. The error remains.
Thank you for any additional help you can offer.
Paul
Thanks for the info. I have Excel setup to ask me about enabling and
disabling macros when opening a worksheet. I've tried both with no luck. I
get the same error when attempting to open this file.
The workbook that I'm opening has always worked before. That workbook and
macros were designed and written by me and they have been working for more
that 5 months now. There are only two worksheets in the workbook and I've
never had any reason to group them together, however, when the workbook
opens with the error, I can see that the two sheets are, in fact, selected.
In addition, a third sheet is now showing, which is labeled "Module1".
Since I can't navigate through the workbook because of the error, I do not
know what is on this sheet.
It is apparent that the workbook is at least opening partially. If I could
just find a way to get the macro text out without having to fully open the
file, then I'd be ok.
I don't recall having any kind of Auto_Open macro. However, I have tried
disabling macros upon opening the file. I've tried the Shift key while
opening, but it still prompts me about the macros to which I choose to
disable. I attempted the command with the " /safe", but that results in a
file not found. I'm using Excel 2000 on a Win2000 computer. I've also
tried a Windows Me computer. The error remains.
Thank you for any additional help you can offer.
Paul