How do i get use macros when the excel doc. is password protected

[PEGJHS]

How do i get use macros when the excel doc. is password protected?? can some answer me please.. :D

[DonkeyOte]

If you don't know the password(s) you don't.

(Also, as a pre-emptive strike, note that questions regards breaking passwords are not permitted on this forum)

[PEGJHS]

I know the password.. i just want some cells to be protected with password... so when i password protect the sheet. my autohide macro won't run ..... please have a answer :D

[Andy Pope]

If you code affects cells that are protected then you need to remove protection first, then change cells, then re-apply protection.

[PEGJHS]

thx. but not working. why doesent the hide macro work on the unprotected celles ? when the sheet is password protected.if i un lock the password protection the macro works perfect...

[Andy Pope]

without seeing the code and the workbook your guess is as good as ours.

[PEGJHS]

Sub Hiding_unwanted_rows()
'

'
ActiveWindow.SmallScroll Down:=-6
Sheets("Summasjon").Select
ActiveWindow.SmallScroll Down:=-15
Range("D6").Select
Selection.AutoFilter
Selection.AutoFilter Field:=4, Criteria1:="<>0", Operator:=xlAnd
ActiveWindow.SmallScroll Down:=-30
End Sub


why dowsent it work when sheet is password protected ???

[PEGJHS]

please help me :D:D:D:D:D

[Andy Pope]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here


Because your routine does not contain any code to handle protection as I suggested.

Change "password" as appropriate.

Please Login or Register  to view this content.

[PEGJHS]

Thank you so much for your help. ooohhh ..