Help w/ protecting all sheets

Tech-Archive recommends: Fix windows errors by optimizing your registry


I have read the threads here on how to protect multiple sheets in a
workbook and not having to protect them 1 by 1. I have copied and
pasted all the different macro's/visual basic script that has been
posted for that purpose, but I can't get it to work and I'm always
getting an error. The error from visual basic says "compile error:
invalid outside procedure" and then the visual basic screen shows the
following:

Range ("AM52")
If Ans >= 0 Then
"+."

It does not like the "AM52" part because it is highlighted in the error
message.

Also, the error I get from recording my own macro step by step is "Run
time error 40036" from visual basic.

Can anyone help me to get this running and tell me what to do step by
step? I looked at this all day last friday and couldn't get it to do
right. Thanks.


--
cnote
------------------------------------------------------------------------
cnote's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26184
View this thread: http://www.excelforum.com/showthread.php?threadid=553206

.

Quantcast