J
JoJo
Hi there. New to group, also fairly new to writing macros.
I have a spreadsheet that will be shared with others - it's called Blank Pet
PkOp.xls. Each person will be able to import data into the file, which then
populates various sheets in the spreadsheet.
Once they have imported their data, I need a way to force a "file save as" -
I used "file get save as", which displays the save as box, but when you go
to save the file it doesn't. I don't want them to be able to save over the
original file, as they will need to use it again in the future. So is there
a way to gray out file save therefore forcing them to save as?
Thanks
JoJo
http://home.comcast.net/~zookeepr/fosters.html
I have a spreadsheet that will be shared with others - it's called Blank Pet
PkOp.xls. Each person will be able to import data into the file, which then
populates various sheets in the spreadsheet.
Once they have imported their data, I need a way to force a "file save as" -
I used "file get save as", which displays the save as box, but when you go
to save the file it doesn't. I don't want them to be able to save over the
original file, as they will need to use it again in the future. So is there
a way to gray out file save therefore forcing them to save as?
Thanks
JoJo
http://home.comcast.net/~zookeepr/fosters.html