VBA Protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Watson - 20 Mar 2006 09:36 GMT

I have created a timesheet that has 2 command buttons, 1 transfers dat
to a data sheet and the other clears the timesheet, but when I pu
protect sheet the VBA button won't work, what am I doing wrong???

Reply to this Message

funkymonkUK - 20 Mar 2006 09:58 GMT

in design mode select the buttons then right click go to format control
then click on the protection tab. untick the locked press ok and protec
the sheet.

I think the reason it is not working is becuase if it is locked and yo
protect it it protects the code that runs

Reply to this Message

broro183 - 20 Mar 2006 10:29 GMT

Hi Chris,

I think that your problem is more likely to be caused by the fact tha
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" cod
module as part of a workbook open macro:

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

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

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

Reply to this Message

David C - 20 Mar 2006 17:01 GMT

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.

> Hi Chris,
>
[quoted text clipped - 17 lines]
> NZ
> Always learning & the best way to learn is to experience...

Reply to this Message