Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Open to modify
I'm hoping this is an easy one for someone.
I have a macro that writes data to an archive sheet every time a button is pressed. This works fine. However I now want the archive sheet viewable to everyone but only updateable by either the marco or a password. to do this i have saved the Archive with a password to modify. That way users can open as read only. However i do not know what addition i need to make to my macro for it to open the Archive to add data to it. So for instance i currently have: Workbooks.Open (ExcelFileB), Password:= "12345" but this is no help with the read only setting. I thought perhaps it would be a simple Workbooks.Modify, password "12345". or something like that. can anyone help please? PS this is Excel 2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open to modify
Try...
Workbooks.Open (ExcelFileB), Password:= "12345", ReadOnly:=False ...since it is one of the args for the Open method. It would serve you well to get familiar with the Object Browser!!! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
|
|||
|
|||
thank you for this, although its not quite addressing the problem. but this could be my fault in not having the write to document set as read only.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open to modify
thank you for this, although its not quite addressing the problem.
but this could be my fault in not having the write to document set as read only. What about applying sheet protection? This requires users to enter a password in order to edit content. VBA can edit if you set it up correctly and lock the project. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel sheet, modify, print and lock | Excel Programming | |||
open then modify file via hyperlink | Excel Programming | |||
Is there an easy way to open a text file and modify only a part of it? | Excel Programming | |||
Unhide sheet on open only if password to modify is given | Excel Programming | |||
Loop through, open, and modify all workbooks in file | Excel Programming |