Protect all sheets at once :confused:

[pipsmultan]

greeting to all Respectable

i am face some "compiler Error Name + argument not found" in the following code plz can anyone help

Please Login or Register  to view this content.

any help from anyone will be highly grateful

Regards

[HaHoBe]

Hi, pipsmultan,

what version of Excel do you use? My Excel2013 doesnīt know
AllowFormattingCells(written correctly) works with Excel2013
Alloweditobjects (unknown) RTE
Alloweditscenarios (unknown) RTE

Code from the Macro-Recorder Excel2013:

Please Login or Register  to view this content.

Ciao,
Holger

[pipsmultan]

Hi, pipsmultan,

what version of Excel do you use? My Excel2013 doesnīt know
AllowFormattingCells(written correctly) works with Excel2013
Alloweditobjects (unknown) RTE
Alloweditscenarios (unknown) RTE

i am Us Excel2013

i trying to do is to protect all sheet in workbook at same time

i hav this following code but it not working correctly and showing "Run Time Error 1004" plz guide me

Please Login or Register  to view this content.

regards

[HaHoBe]

Hi, pipsmultan,

whatīs the use in first using "Secret" and then claiming a run-time error when using "password"? The passwords should be identical I assume. There has been no alteration to Calcualtion so why the command (I donīt know how your data looks like)?

Please Login or Register  to view this content.

Ciao,
Holger

[pipsmultan]

That is amazing...that formula is excellent. Thanks so much for your help, it is very much appreciated !

Best Regards