LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
prompt user to save file as {desired_name} and save it to a variab GeneWan Excel Programming 1 January 5th 07 06:46 AM
disable save and saveas from menubar and save via command button Steve E Excel Programming 5 September 13th 06 11:51 PM
Disable save, save as, but allow save via command button TimN Excel Programming 10 September 1st 06 07:05 PM
How to diasble save and save as menu but allow a save button hon123456 Excel Programming 1 June 12th 06 09:50 AM
Using Button on User Form to save Data to specific Cell?? DarnTootn Excel Programming 2 May 13th 06 03:20 PM


All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"