| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
