Protecting forumla within a workbook

[Legacy 93538]

HI

i ahve a macro which opens and template workbook and pastes data into it, however in the template i have charts which have forumlas within the titles. I need to add code to my macro which protects these forumlas so that when they are selected the forumla is hidden.

However i dont know how to protect formlas or sheets within vba does anyone how to do this?

Thanks

Jessicaseymour

 

[Andrew Poulsom]

Like this?

ActiveSheet.Protect

 

[Legacy 93538]

Hi

Thanks works perfectly! Thank your for all your help i truly appricate it