Results 1 to 4 of 4

Macro Saving Only!

Threaded View

ultimastryder Macro Saving Only! 06-28-2010, 08:52 PM
ultimastryder Re: Macro Saving Only! 06-29-2010, 11:54 AM
romperstomper Re: Macro Saving Only! 06-29-2010, 12:05 PM
ultimastryder Re: Macro Saving Only! 06-29-2010, 12:43 PM
  1. #1
    Registered User
    Join Date
    02-22-2010
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2007
    Posts
    41

    Macro Saving Only!

    Hey Guys,

    So heres my dilemma. Since I don't know understand Custom UI, Ribbonx stuff. I need another solution.

    I have a workbook that should only be able to be saved from a save button that I created in my workbook. In which i have assigned a macro too.

    The user shouldn't be able to save any other way. Currently this code keeps my save macro from working.

    Ideas? I thought about using an if statement, but wasn't sure how to go about it.

    
    Private Sub Workbook_BeforeSave(ByVal SaveUI As Boolean, Cancel As Boolean)
        Cancel = True
        MsgBox "You cannot save this workbook. Please use the save icon provided in this Workbook."
    
    End Sub
    Last edited by ultimastryder; 06-29-2010 at 12:43 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1