prevent people from use save as function in my workbook....please help me
Posted by Newby on March 31, 2000 3:46 AM
some1 have send this below code on this board..the problem
i've paste in it my workbook called "ACCOUNT"
but it dowsn't worked.any ideas why it doesn't work..
p/s : also 1 2 know what is UI stand in below code
thanks n regards
Private Sub workbook_beforesave(ByVal SaveAsUI As Boolean, cancel As Boolean)
MsgBox ("Sorry you cannot save this workbook using this method")
SaveAsUI = False
cancel = True