Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External reference an entire worksheet
Is there any way to reference a worksheet from a saved
file in entirety to another file other than manually keying in the references and then filling in all the cells? Here is what I want to accomplish. File A has 10 worksheets. The first 3 of these do not need to be secure, but the remaining 7 do, and are based on the first 3. I would like to give individuals access to these first 3 sheets for input purposes, but not to the secure information. I thought this might be accomplished by creating a second workbook with just the first 3 input pages, and then have the first book precisely reference those 3 pages, as shown below. Workbook AWorkbook B page 1page 1 page 2page 2 page 3page 3 page 4-10 Thanks, Pradhan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
External reference an entire worksheet
reference a worksheet from a saved file
In simple terms, yes. Just use the normal method of referring t another worksheet, ie. in cell A1 of a sheet in Book2 put :- =[Book1.xls]Sheet1!$A$1 and copy/paste to all other cells. In this case I do not think that this is the solution that you reall want. Perhaps better would be to use the VeryHidden propery of th sheet Visible property. This can only be done with code and prevent sheet names appearing in any menu listings. It is reset in code b using .Visible = True. Something like this : Code ------------------- For s = 4 To 10 Worksheets(s).Visible = xlVeryHidden Next ------------------- -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
External reference an entire worksheet
Yes, the first method I am aware of. I was looking for a
simpler method...perhaps a worksheet function that simply references an entire worksheet instead of cell by cell. I'll check out the second method. Thanks, Pradhan -----Original Message----- reference a worksheet from a saved file In simple terms, yes. Just use the normal method of referring to another worksheet, ie. in cell A1 of a sheet in Book2 put :- =[Book1.xls]Sheet1!$A$1 and copy/paste to all other cells. In this case I do not think that this is the solution that you really want. Perhaps better would be to use the VeryHidden propery of the sheet Visible property. This can only be done with code and prevents sheet names appearing in any menu listings. It is reset in code by using .Visible = True. Something like this : Code: -------------------- For s = 4 To 10 Worksheets(s).Visible = xlVeryHidden Next -------------------- --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference external worksheet whose name is in a cell | Excel Worksheet Functions | |||
Using cell value to reference external worksheet? | Excel Worksheet Functions | |||
Formula Contains an invalid external reference to a worksheet | Setting up and Configuration of Excel | |||
How do I build a reference to an external worksheet? | Excel Worksheet Functions | |||
Finding an external reference on a worksheet | Excel Discussion (Misc queries) |