View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default 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