unfortunately not to much information needed
--
BD3


"Lowkey" wrote:

Is it possible to create a 4th workbook with a sheet containing the cells you
only want updated so the user doesn't see the other sheets or cells you don't
want them to, then link your updates to the 4th workbook?

"bigdaddy3" wrote:

can i do that with a macro as i am using 3 different workbooks with sheet
tabs not showing and i dont want the whole workbook showing i just need to
update some cell information
--
BD3


"Chip Pearson" wrote:

A worksheet must be contained within a workbook. There is no such
thing as a sheet without a containing workbook. You must open the
workbook and then go to the desired worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"bigdaddy3" wrote in
message
...
I would like to write a macro that will open a particular
worksheet in a
closed workbook that contains named sheets,when i use the
application.open
route with the path details, i can get the whole book to open
but i want a
particular sheet of that book. Can anyone help please
--
BD3