Save file as read-only

[mohan.r1980]

Hello Frineds

I am creating read-only excel file
my code is like this:

Please Login or Register  to view this content.

Problem is that when i open this file that time excel show me msg (sample Attached)
i dont want to excel show this msgbox
Excel completly save as read-only and no have rights to change the matter or rename it.

[JazzKult]

As your code says, Read only is just a recommendation that the user can dismiss. If you want this to be permanent you need the code to protect the file.

[Fotis1991]

What's about?

Please Login or Register  to view this content.

[mohan.r1980]

Hi friends,
thanks for reply
i have change the code like this:

Please Login or Register  to view this content.

but result is same
if i unprotect workbook by password then still i want to open it with Read-Only mode.
first thing i dont want opening password, but if workbook can't take read-only command without protection then its ok.
while i try both the option but result is same. when i unprotect this file then i can change the figure and save it.

See i just want that user can change the figure as he wants but he can not be save the file as same name, excel should ask him save as option.

thatswhy i want this file as a read-only.

[JazzKult]

Hmm in that case maybe a beforesave event could do the trick? I think I had some code that did just that. Ok. looked into this and if the end user would save a copy of the file he wouldn't be able to overwrite it either.

There might be a simpler solution though, why not set up a password to modify the file? File -> Save as -> Tools -> General options -> Password to modify

Try and let us know if that works for you.

[lloydgodin]

Try saving the file as a TEMPLATE. THen when the end user opens it they can edit but have to save it as a New Document.

Please Login or Register  to view this content.

[mohan.r1980]

Its working fine
thanks