ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't find project or library (https://www.excelbanter.com/excel-discussion-misc-queries/2968-cant-find-project-library.html)

Tracey

Can't find project or library
 
I started doing a tutorial from the Microsoft site on macros, but didn't
complete it (I downloaded the tutorial, but hadn't begun writing a macro).
However, since I worked in that tutorial, I have been getting the above error
message in every Excel worksheet I try to enter a cell reference into. For
example, if I enter a reference to another cell on another worksheet, the
error message appears every time. How can I make this stop?

Earl Kiosterud

Tracey,

You say you're doing a macro, but you also say you're putting a cell
reference into a worksheet. ??? This could mean one of a few things. Be
more specific.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tracey" wrote in message
...
I started doing a tutorial from the Microsoft site on macros, but didn't
complete it (I downloaded the tutorial, but hadn't begun writing a macro).
However, since I worked in that tutorial, I have been getting the above
error
message in every Excel worksheet I try to enter a cell reference into. For
example, if I enter a reference to another cell on another worksheet, the
error message appears every time. How can I make this stop?




Tracey

For example, in any cell in the worksheet I might edit by changing a cell
reference from 'Sheet 1'!B7 to 'Sheet 1'!C12, the error message appears. I
was not attempting to write a macro. The error message only started once I
opened the Microsoft Excel tutorial on how to write macros. I started the
tutorial, but did not finish it. I had only downloaded the sample from the
Microsoft site, but had not yet even begun to do the tutorial when I closed
it. When I resumed work on my worksheet, this error message started appearing
every time I tried to change a cell as illustrated above.

"Earl Kiosterud" wrote:

Tracey,

You say you're doing a macro, but you also say you're putting a cell
reference into a worksheet. ??? This could mean one of a few things. Be
more specific.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tracey" wrote in message
...
I started doing a tutorial from the Microsoft site on macros, but didn't
complete it (I downloaded the tutorial, but hadn't begun writing a macro).
However, since I worked in that tutorial, I have been getting the above
error
message in every Excel worksheet I try to enter a cell reference into. For
example, if I enter a reference to another cell on another worksheet, the
error message appears every time. How can I make this stop?





Earl Kiosterud

Tracey,

Hmmm. This sounds as if Excel isn't feeling too good. Try the stuff at
www.smokeylake.com/excel. Click "VFAQ" (very frequently asked questions).
and look at "Excel acts generally stupid." Always worth a try.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tracey" wrote in message
...
For example, in any cell in the worksheet I might edit by changing a cell
reference from 'Sheet 1'!B7 to 'Sheet 1'!C12, the error message appears. I
was not attempting to write a macro. The error message only started once I
opened the Microsoft Excel tutorial on how to write macros. I started the
tutorial, but did not finish it. I had only downloaded the sample from the
Microsoft site, but had not yet even begun to do the tutorial when I
closed
it. When I resumed work on my worksheet, this error message started
appearing
every time I tried to change a cell as illustrated above.

"Earl Kiosterud" wrote:

Tracey,

You say you're doing a macro, but you also say you're putting a cell
reference into a worksheet. ??? This could mean one of a few things. Be
more specific.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tracey" wrote in message
...
I started doing a tutorial from the Microsoft site on macros, but didn't
complete it (I downloaded the tutorial, but hadn't begun writing a
macro).
However, since I worked in that tutorial, I have been getting the above
error
message in every Excel worksheet I try to enter a cell reference into.
For
example, if I enter a reference to another cell on another worksheet,
the
error message appears every time. How can I make this stop?







Tracey

Thanks, I will.

"Earl Kiosterud" wrote:

Tracey,

Hmmm. This sounds as if Excel isn't feeling too good. Try the stuff at
www.smokeylake.com/excel. Click "VFAQ" (very frequently asked questions).
and look at "Excel acts generally stupid." Always worth a try.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tracey" wrote in message
...
For example, in any cell in the worksheet I might edit by changing a cell
reference from 'Sheet 1'!B7 to 'Sheet 1'!C12, the error message appears. I
was not attempting to write a macro. The error message only started once I
opened the Microsoft Excel tutorial on how to write macros. I started the
tutorial, but did not finish it. I had only downloaded the sample from the
Microsoft site, but had not yet even begun to do the tutorial when I
closed
it. When I resumed work on my worksheet, this error message started
appearing
every time I tried to change a cell as illustrated above.

"Earl Kiosterud" wrote:

Tracey,

You say you're doing a macro, but you also say you're putting a cell
reference into a worksheet. ??? This could mean one of a few things. Be
more specific.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tracey" wrote in message
...
I started doing a tutorial from the Microsoft site on macros, but didn't
complete it (I downloaded the tutorial, but hadn't begun writing a
macro).
However, since I worked in that tutorial, I have been getting the above
error
message in every Excel worksheet I try to enter a cell reference into.
For
example, if I enter a reference to another cell on another worksheet,
the
error message appears every time. How can I make this stop?








All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com