Understanding Templates
 

Hello Everybody,

I have Excel 2003 Pro on WinXP SP2.

In the templates that are provided with Excel, when we click on certain
cells, the relevant information appears in a yellow box which doesn't seem
to be a comment (technically) and I am unable to edit these boxes. What are
these boxes, and how can I edit and make them?

How can I remove Lotus 1-2-3 from templates provided with Excel? (I know
nothing about Lotus 1-2-3 but I do have experience in quite complex
programming of VBA of Excel.)
A sheet which I have copied (to myFile.xls) from a template based file (say
this file is called xyz.xls), makes xyz.xls to open every time I open
myFile.xls. I cannot see any VBA behind that sheet except that I wrote which
doesn't make any other file open. I thing that file opening is done by Lotus
1-2-3 which has been hidden in that sheet. I have some hints about this
possibility. What do you think? How can I break this file-opening
connection? I have already broken all links using Edit Links.

Thank you,
--
Syed Zeeshan Haider


------------------------------------------------------------------------------------------------------------------------------
Download a free game to play with Internet Explorer from
http://szh.20m.com/entertainment/olwg.html

Understanding Templates
 

Have you looked in tools references (in the VBE) and made sure myfile.xls
does not have a reference to xyz.xls.

--
Regards,
Tom Ogilvy

"Syed Zeeshan Haider" wrote in message
...
Hello Everybody,

I have Excel 2003 Pro on WinXP SP2.

In the templates that are provided with Excel, when we click on certain
cells, the relevant information appears in a yellow box which doesn't seem
to be a comment (technically) and I am unable to edit these boxes. What
are
these boxes, and how can I edit and make them?

How can I remove Lotus 1-2-3 from templates provided with Excel? (I know
nothing about Lotus 1-2-3 but I do have experience in quite complex
programming of VBA of Excel.)
A sheet which I have copied (to myFile.xls) from a template based file
(say
this file is called xyz.xls), makes xyz.xls to open every time I open
myFile.xls. I cannot see any VBA behind that sheet except that I wrote
which
doesn't make any other file open. I thing that file opening is done by
Lotus
1-2-3 which has been hidden in that sheet. I have some hints about this
possibility. What do you think? How can I break this file-opening
connection? I have already broken all links using Edit Links.

Thank you,
--
Syed Zeeshan Haider


--------------------------------------------------------------------------
----------------------------------------------------
Download a free game to play with Internet Explorer from
http://szh.20m.com/entertainment/olwg.html

Understanding Templates
 

One more guess...

You have a button that's assigned a macro in that other workbook.

So when you click the button (or some other object), excel knows to open that
other workbook.

(And you don't notice that the second workbook is open until you clicked the
button???)

Syed Zeeshan Haider wrote:

Hello Everybody,

I have Excel 2003 Pro on WinXP SP2.

In the templates that are provided with Excel, when we click on certain
cells, the relevant information appears in a yellow box which doesn't seem
to be a comment (technically) and I am unable to edit these boxes. What are
these boxes, and how can I edit and make them?

How can I remove Lotus 1-2-3 from templates provided with Excel? (I know
nothing about Lotus 1-2-3 but I do have experience in quite complex
programming of VBA of Excel.)
A sheet which I have copied (to myFile.xls) from a template based file (say
this file is called xyz.xls), makes xyz.xls to open every time I open
myFile.xls. I cannot see any VBA behind that sheet except that I wrote which
doesn't make any other file open. I thing that file opening is done by Lotus
1-2-3 which has been hidden in that sheet. I have some hints about this
possibility. What do you think? How can I break this file-opening
connection? I have already broken all links using Edit Links.

Thank you,
--
Syed Zeeshan Haider

------------------------------------------------------------------------------------------------------------------------------
Download a free game to play with Internet Explorer from
http://szh.20m.com/entertainment/olwg.html

--

Dave Peterson

Understanding Templates
 

The yellow boxes with dialog are Data Validation messages.

Select one of those cells and DataValidation to edit.


Gord Dibben Excel MVP

On Mon, 23 May 2005 16:00:52 -0400, "Syed Zeeshan Haider"
wrote:

Hello Everybody,

I have Excel 2003 Pro on WinXP SP2.

In the templates that are provided with Excel, when we click on certain
cells, the relevant information appears in a yellow box which doesn't seem
to be a comment (technically) and I am unable to edit these boxes. What are
these boxes, and how can I edit and make them?

How can I remove Lotus 1-2-3 from templates provided with Excel? (I know
nothing about Lotus 1-2-3 but I do have experience in quite complex
programming of VBA of Excel.)
A sheet which I have copied (to myFile.xls) from a template based file (say
this file is called xyz.xls), makes xyz.xls to open every time I open
myFile.xls. I cannot see any VBA behind that sheet except that I wrote which
doesn't make any other file open. I thing that file opening is done by Lotus
1-2-3 which has been hidden in that sheet. I have some hints about this
possibility. What do you think? How can I break this file-opening
connection? I have already broken all links using Edit Links.

Thank you,

Understanding Templates
 

Thanks for info! I appreciate it.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
The yellow boxes with dialog are Data Validation messages.

Select one of those cells and DataValidation to edit.


Gord Dibben Excel MVP

On Mon, 23 May 2005 16:00:52 -0400, "Syed Zeeshan Haider"
wrote:

Hello Everybody,

I have Excel 2003 Pro on WinXP SP2.

In the templates that are provided with Excel, when we click on certain
cells, the relevant information appears in a yellow box which doesn't seem
to be a comment (technically) and I am unable to edit these boxes. What
are
these boxes, and how can I edit and make them?

How can I remove Lotus 1-2-3 from templates provided with Excel? (I know
nothing about Lotus 1-2-3 but I do have experience in quite complex
programming of VBA of Excel.)
A sheet which I have copied (to myFile.xls) from a template based file
(say
this file is called xyz.xls), makes xyz.xls to open every time I open
myFile.xls. I cannot see any VBA behind that sheet except that I wrote
which
doesn't make any other file open. I thing that file opening is done by
Lotus
1-2-3 which has been hidden in that sheet. I have some hints about this
possibility. What do you think? How can I break this file-opening
connection? I have already broken all links using Edit Links.

Thank you,

Understanding Templates
 

Actually No!

xyz.xls opens as soon as I open myFile.xls. I have tried to remove all
previous macro connections from the sheet.

"Dave Peterson" wrote in message
...
One more guess...

You have a button that's assigned a macro in that other workbook.

So when you click the button (or some other object), excel knows to open
that
other workbook.

(And you don't notice that the second workbook is open until you clicked
the
button???)

Syed Zeeshan Haider wrote:

Hello Everybody,

I have Excel 2003 Pro on WinXP SP2.

In the templates that are provided with Excel, when we click on certain
cells, the relevant information appears in a yellow box which doesn't
seem
to be a comment (technically) and I am unable to edit these boxes. What
are
these boxes, and how can I edit and make them?

How can I remove Lotus 1-2-3 from templates provided with Excel? (I know
nothing about Lotus 1-2-3 but I do have experience in quite complex
programming of VBA of Excel.)
A sheet which I have copied (to myFile.xls) from a template based file
(say
this file is called xyz.xls), makes xyz.xls to open every time I open
myFile.xls. I cannot see any VBA behind that sheet except that I wrote
which
doesn't make any other file open. I thing that file opening is done by
Lotus
1-2-3 which has been hidden in that sheet. I have some hints about this
possibility. What do you think? How can I break this file-opening
connection? I have already broken all links using Edit Links.

Thank you,
--
Syed Zeeshan Haider

------------------------------------------------------------------------------------------------------------------------------
Download a free game to play with Internet Explorer from
http://szh.20m.com/entertainment/olwg.html

--

Dave Peterson

Understanding Templates
 

And you checked for the reference that Tom suggested???

Syed Zeeshan Haider wrote:

Actually No!

xyz.xls opens as soon as I open myFile.xls. I have tried to remove all
previous macro connections from the sheet.

"Dave Peterson" wrote in message
...
One more guess...

You have a button that's assigned a macro in that other workbook.

So when you click the button (or some other object), excel knows to open
that
other workbook.

(And you don't notice that the second workbook is open until you clicked
the
button???)

Syed Zeeshan Haider wrote:

Hello Everybody,

I have Excel 2003 Pro on WinXP SP2.

In the templates that are provided with Excel, when we click on certain
cells, the relevant information appears in a yellow box which doesn't
seem
to be a comment (technically) and I am unable to edit these boxes. What
are
these boxes, and how can I edit and make them?

How can I remove Lotus 1-2-3 from templates provided with Excel? (I know
nothing about Lotus 1-2-3 but I do have experience in quite complex
programming of VBA of Excel.)
A sheet which I have copied (to myFile.xls) from a template based file
(say
this file is called xyz.xls), makes xyz.xls to open every time I open
myFile.xls. I cannot see any VBA behind that sheet except that I wrote
which
doesn't make any other file open. I thing that file opening is done by
Lotus
1-2-3 which has been hidden in that sheet. I have some hints about this
possibility. What do you think? How can I break this file-opening
connection? I have already broken all links using Edit Links.

Thank you,
--
Syed Zeeshan Haider

------------------------------------------------------------------------------------------------------------------------------
Download a free game to play with Internet Explorer from
http://szh.20m.com/entertainment/olwg.html

--

Dave Peterson

--

Dave Peterson