Disable Save Button?

robfo0 · May 14th, 2002, 03:53 PM

Hi everyone,

I have a file that auto saves when closed. But there seems to be a problem when users manually save the file. Is there a way to prevent manual saving of the file and make it ONLY save from the close macro i have in place already? I would like to prevent the save button AND shortcut save methods but allow my close save.

How could i do this?

Thanks

Ricky Morris · May 14th, 2002, 04:06 PM

See the following post.

http://www.mrexcel.com/board/viewtop...c=7848&forum=2

Tom Schreiner · May 14th, 2002, 04:17 PM

Hi Rob...
Alternative which I have used myself.

Public UserSave as Boolean
in any standard module.

UserSave = True in Workbook open event sub

In your workbook before save event:
Cancel = UserSave

In your macro which saves the book:
UserSave = False 'before saving

Tom

robfo0 · May 14th, 2002, 04:25 PM

Thanks guys, Hmm, i did a search for disable save and that post did not come up. oh well, thanks

May 14th, 2002, 04:06 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	See the following post. http://www.mrexcel.com/board/viewtop...c=7848&forum=2 __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 03:53 PM	#1
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Hi everyone, I have a file that auto saves when closed. But there seems to be a problem when users manually save the file. Is there a way to prevent manual saving of the file and make it ONLY save from the close macro i have in place already? I would like to prevent the save button AND shortcut save methods but allow my close save. How could i do this? Thanks

May 14th, 2002, 04:17 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Rob... Alternative which I have used myself. Public UserSave as Boolean in any standard module. UserSave = True in Workbook open event sub In your workbook before save event: Cancel = UserSave In your macro which saves the book: UserSave = False 'before saving Tom

May 14th, 2002, 04:25 PM	#4
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Thanks guys, Hmm, i did a search for disable save and that post did not come up. oh well, thanks