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
Bookmarks