add protection dialog box to macro in user form

[wotadude]

I want to use the inbuilt xldialogProtectDocument dialog box to set worksheet protection from a user form.
I am unsure of the code syntax to get this to work

i tried -
application.xldialogProtectDocument.show
but i get a runtime error.

Can someone to help me with this please.

[Leith Ross]

Hello wotadude,

Here is the syntax...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[wotadude]

thanks for your help Leith, i was close