Or [which is simpler, and I found works well], 'Share' the workbook [ie
Tools, Share Workbook, tick the box] the save and make it Read only.

Sharing protects your macro and VB from sight/editing, and write protect
stops others turning off sharing.

"broro183" wrote:


Hi Chris,

I think that your problem is more likely to be caused by the fact that
the sheet is protected (b/c depending on the tools - protect sheet"
options chosen, it is probable that the time sheet can not be cleared)
rather than the property of the command buttons.

Try entering the following line of code into the "this workbook" code
module as part of a workbook open macro:

activesheet.Protect Password:="Password", UserInterfaceOnly:=True

(I've explained it a little in
http://excelforum.com/showthread.php?t=506721 & others have explained
it too - try searching for (UserInterfaceOnly & protect). For other
info, search "protect method" in VBE Help or by Googling.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=524255