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,
|