showing excel file in intranet

S

Soe

I like to make my excel file in corporate intranet
however, I want public to see particular sheet at begining whenever they
open from intranet
secondly, i want to restrict a few sheets from showing to public
any way I can do this?
 
J

Jonathan Rynd

Soe said:
I like to make my excel file in corporate intranet
however, I want public to see particular sheet at begining whenever they
open from intranet
Click to expand...

create a macro called auto_open that activates the desired sheet.
secondly, i want to restrict a few sheets from showing to public
any way I can do this?
Click to expand...

password protect the sheets then hide them
 
Top