Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to have a cell that I have added Validation to and would like to
specify list and then use a =name as the source. I would then like the name to be a reference to some cells on a worksheet in an add-in, is this possible? I have created the name in the xla, but I can not simply use =name as the source in my other workbook, it complains about not be able to find the name. -- Trefor |
#2
![]() |
|||
|
|||
![]()
Debra Dalgleish explains it all:
http://contextures.com/xlDataVal05.html Trefor wrote: I would like to have a cell that I have added Validation to and would like to specify list and then use a =name as the source. I would then like the name to be a reference to some cells on a worksheet in an add-in, is this possible? I have created the name in the xla, but I can not simply use =name as the source in my other workbook, it complains about not be able to find the name. -- Trefor -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
Thanks Dave.
-- Trefor "Dave Peterson" wrote: Debra Dalgleish explains it all: http://contextures.com/xlDataVal05.html Trefor wrote: I would like to have a cell that I have added Validation to and would like to specify list and then use a =name as the source. I would then like the name to be a reference to some cells on a worksheet in an add-in, is this possible? I have created the name in the xla, but I can not simply use =name as the source in my other workbook, it complains about not be able to find the name. -- Trefor -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) |