Protecting forumla in VBA

[jeskit]

Hi

Does anyone know how to protect a worksheet so that it does not show the forumla within the cells in VBA?

have been using

Please Login or Register  to view this content.

but its not doing anything as when you use the workbook it dose not ask for a password.

thanks

jeskit

[Andy Pope]

you mention worksheet but your code is using the activeworkbook

what exactly are you trying to do and have you tried using the macro recorder?

[jeskit]

Hi

Thank you for replying

sorry what i meant was that the macro is one worksheet and the the macro is opening anotehr macro which has forumla within in and my code pastes data into the workbook and then i want it to protect forumla. I have been told there is a way to protect the forumla so when you click the cell with the formula it doesn't show the forumla but i have no idea how to do that.

The code i put in my orginal post is what i am using but it doesn't seem to work as i want to password protect the workbook teh macro opens.

does that make sense?

[Andy Pope]

maybe you type too quickly...

the macro is one worksheet and the the macro is opening anotehr macro

If you display the cells format dialog you will see on the Protection tab you can have the contents of the cell Hidden. This will stop the formula displaying in the formula bar.

Once you have set the Hidden property you need to protect the worksheet.

And if you want you can then protect the workbook, but that will have no effect until the workbook is closed and reopened.

Please Login or Register  to view this content.

[jeskit]

Hi

Thanks works perfectly.....Thank you for help i appraciate it