Save button, VBA protected, allow user to define where to save

[mail]

Ok, I think this should be fairly simple but seem to have a mental
block.

I have a work book that is VBA protected, when its sent to someone
they can open it but not save changes they make in the workbook.

The solution that seems logical is to have a "save" button in the
workbook that takes the protection off and saves it where the user
choses then re-protects it.

I can do it apart from the bit of letting them chose where.

Is there a simple way to do this?

Im not that knowledgable in Excel so jargon will confuse me easily!

)

Thank you in advance

Toni

 

[Dave Peterson]

Take a look at VBA's help for application.getsaveasfilename

It doesn't do the save--it just gets a name. Your code has to do the rest.

If you sent them a workbook that had a password to modify
(file|saveas|tools|general options in xl2003), would that be sufficient?

 

[mail]

Thankyou for your quick reply,

But realised my silly error - I was saving it as excel 07' opps!