SAVE AS :Then protect all sheets

Hi,

I am creating one file through my macro

Please Login or Register  to view this content.

I WANT TO PROTECT ALL the sheets in newly created worksheet that is (Report_*).
Means user can view the file but he will not be able to select any cell

Please suggest.

Thanks


Tanya

Hello there,

The following lines of code should do it.

Please Login or Register  to view this content.

Thanks!!
But when i am combining your code with my code its not working.
I cant skip my code because I have to save those sheets.

Try the following:

Please Login or Register  to view this content.

thanks its working.
But please add to my information
when i am adding

Please Login or Register  to view this content.

at the end after saving it is again asking you want to save the changes yo made.
I dont want that pop up so how to disable that pop up???

Add try to the end of the string of code, this will tell the code that you want to save, false would indicate not to save changes.

Please Login or Register  to view this content.

If this completes your questions please mark this thread SOLVED and maybe give a little star tap if I have helped. Thanks!