O
olly
Hi guys
I've got a 2 sheet workbook, for which sheet 1 is a user
form, that looks up info from sheet 2. Sheet 2 changes
reguarly-probably once a week, as its stock details.
My question-is there a way to publish this excel workbook
online, so that users, instead of having to use their
laptops and download the whole workbook each time, can tap
into it online ? if so, how ? sheet 1 is the only sheet i
wish for users to see, i.e sheet 2 invisible, but sheet 1
needs to look up info from sheet 2. also, one point of
note-sheet 1-the user form, has macros in-the one main one
being whereby the user presses on a button once finished,
and it sends the active sheet(just sheet1) to a specified
email recipient via MS outlook on their computer
any1 able to help me out ? one more thing to note-any
changes made to the workbook online by users should not be
saved-and more than one user should be able to user the
form each time.
one more thing-i don't want the users to have to download
the workbook-i would like them to be able to use its full
functionality online-is this possible?
any help REALLY appreciated
cheers
olly
I've got a 2 sheet workbook, for which sheet 1 is a user
form, that looks up info from sheet 2. Sheet 2 changes
reguarly-probably once a week, as its stock details.
My question-is there a way to publish this excel workbook
online, so that users, instead of having to use their
laptops and download the whole workbook each time, can tap
into it online ? if so, how ? sheet 1 is the only sheet i
wish for users to see, i.e sheet 2 invisible, but sheet 1
needs to look up info from sheet 2. also, one point of
note-sheet 1-the user form, has macros in-the one main one
being whereby the user presses on a button once finished,
and it sends the active sheet(just sheet1) to a specified
email recipient via MS outlook on their computer
any1 able to help me out ? one more thing to note-any
changes made to the workbook online by users should not be
saved-and more than one user should be able to user the
form each time.
one more thing-i don't want the users to have to download
the workbook-i would like them to be able to use its full
functionality online-is this possible?
any help REALLY appreciated
cheers
olly