View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mail@toniasears.co.uk is offline
external usenet poster
 
Posts: 4
Default Save button, VBA protected, allow user to define where to save

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!

:o)

Thank you in advance

Toni