addin to update footer

[vinod_excel]

need a addin which will ask for document type and update the footer with that eg. confidential or internal

[JasperD]

No add-in needed, you'll have to make a userform with two option buttons (Confidential / Internal) and then set their action as follows :

Please Login or Register  to view this content.

I assume you want to show the popup before print or something, so in the worksheet code, set :

Please Login or Register  to view this content.

Please click the * below if this helps