Macro Saving Only!

[ultimastryder]

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.

Please Login or Register  to view this content.

[ultimastryder]

If I cannot use an if statment to control the BeforeSave event, then can someone please explain or direct me to somewhere I can understand adding XML to my Excel file??? (Which seems more complicated)

[romperstomper]

With the above BeforeSave code in place, your save macro simply needs to have:

Please Login or Register  to view this content.

[ultimastryder]

Yay! Thanks Romperstomper!