ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can you fix this?? vbreadonly (https://www.excelbanter.com/excel-programming/310539-can-you-fix-vbreadonly.html)

Simon Lloyd[_565_]

Can you fix this?? vbreadonly
 

HI all,

Any thoughts on the above?, i really need to solve this proble
otherwise the back up copy will replicate its self if someone opens i
and a date change has occurred and this will cause a great deal o
confusion.
Hope you can help!

Simon

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=25742


No Name

Can you fix this?? vbreadonly
 
hi,
I am not entire sure what you want but i guess ...
from excel help....
Set properties to make a workbook read-only
If you make a workbook read-only, changes to the workbook
cannot be saved in the same workbook file. You can,
however, use the Save As command (File menu) to save
another version of the file with a different name or in
another location.

1.On the Windows Start menu, point to Programs, and then
click Windows Explorer.
2.In the Exploring window, open the drive or folder that
contains the file.
3.Click the file name.
4.On the File menu, click Properties.
5.On the General tab, select the Read-only check box.

but i am not sure this will stop your backup copy from
replicating itself.
-----Original Message-----

HI all,

Any thoughts on the above?, i really need to solve this

problem
otherwise the back up copy will replicate its self if

someone opens it
and a date change has occurred and this will cause a

great deal of
confusion.
Hope you can help!

Simon.


--
Simon Lloyd
----------------------------------------------------------

--------------
Simon Lloyd's Profile:

http://www.excelforum.com/member.php?
action=getinfo&userid=6708
View this thread:

http://www.excelforum.com/showthread...hreadid=257424

.



All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com