Hi all,
i have a UserForm that populates the WB it is sits in, but what i need it to do is paste into a read only WB, i have the code to do the copying but i am stumped on the code to
1 remove read only and open file
2 copy data and then re-save (same filename) as read only
this needs to be done when a Commandbutton is pressed on UF
the read only WB is only read only and not password protected as users still need access to it
any help would be greatly appreciated
i have a UserForm that populates the WB it is sits in, but what i need it to do is paste into a read only WB, i have the code to do the copying but i am stumped on the code to
1 remove read only and open file
2 copy data and then re-save (same filename) as read only
this needs to be done when a Commandbutton is pressed on UF
the read only WB is only read only and not password protected as users still need access to it
any help would be greatly appreciated
