I wrote some code in VBA in order to make a excel form available fo
multiple data entry (share workbook). As the spreadsheet has som
linked data field, when people open it, it always ask for whether t
update all links.

Can VBA automate this ?

Also, I use some code to save the workbook and the workbook thus alway
ask users whether s/he want to save as a new name or replace the ol
file with the same name.

Can VBA automate this as well?

When I try to use the VBA code to make a shared workbook into exclusiv
use, it always ask user for confirmation by a pop-up (ask for yes o
no).

Can VBA automate this ?

Thanks a LOT....


Jason

--
Jason
-----------------------------------------------------------------------
Jasons's Profile: http://www.excelforum.com/member.php...fo&userid=1610
View this thread: http://www.excelforum.com/showthread.php?threadid=27602