Autofilter
29.11.2002 11:24:04
jörg
ich schreibe ein Programm fuer jemanden, der den Code nicht sehen darf. Jetzt hat sich diese Person beschwert, das Programm wuerde nicht laufen, und hat mir diese Mail geschrieben:
> ' Two possible problems: If userinterfaceonly is used, it will not be
remembered by excel when the workbook is closed,
> 'therefore it needs to be stated in a workbook-open sub.
> 'Another possible reason can be, that several versions of Excel likes to know
the password in subs unprotecting sheets. Protecting is no problem but
> ' it seems to get less easy for each new version to unprotect.
>
> In the VBE accessed with Alt + F11
> 'ThisWorkbook Module:
> Private Sub Workbook_Open()
> for each sh in ThisWorkbook
> Worksheets sh.Activate
> sh.EnableAutoFilter = True
> sh.Protect Password:="XXX", UserInterFaceOnly:=True
> Next
> End Sub
> 'Or
> 'In the regular code module where your macro code is
> Sub YourMacroName()
> ActiveSheet.UnProtect Password:="XXX"
> [Your macro code]
> ActiveSheet.Protect Password:="XXX"
> End Sub
Habe ich wirklich was falsch gemacht, oder will diese Person nur mein Passwort??
Danke schonmal
Jörg