Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
saved templates opening as templates | Excel Discussion (Misc queries) | |||
Understanding formula | Excel Worksheet Functions | |||
Understanding SUMPRODUCT() | Excel Worksheet Functions | |||
Excel is opening templates as templates instead of as worksheets | Setting up and Configuration of Excel | |||
Understanding a formula | Excel Worksheet Functions |