Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs Read Only
Below is the code I use to make a copy of sheet 3 in my work book and save
just sheet 3 to a new file saved as a unique value in cell B15. The new files will be accessable by many people and I would like it if the file was saved as Read Only so they dont alter any content in the file. Is there an easy way to alter my VBA code to make this possible rather than going through each file and protecting them myself? Sheets("Sheet3").Select Sheets("Sheet3").Copy ActiveWindow.ScrollRow = 1 ActiveWorkbook.SaveAs Filename:="\\Hci\HCI Share\C of A's - Building 4\00-RMHTest-6 Parameters\" & _ Range("B15").Value & ".xls" ActiveWorkbook.Close Sheets("Sheet1").Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs Read Only
EDIT:
The new files will be accessable by many people and I would like it if the file was saved as Read Only or saved with the entire sheet protected so they dont alter any content in the file. Is there an easy way to alter my VBA code to make this possible rather than going through each file and protecting them myself? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
Help with SaveAs | Excel Programming | |||
More help with SaveAs | Excel Programming |