I have a save button running a macro that validates before saving. Is there a way to remove all other save options (alt f a, ctrl s, the toolbar save button, etc.) but just from this one workbook?
A while ago I tried playing with a code that did this but it did it through out excel. not cool
I assume that I need a case statement that says something like
case.sheet="filename"
remove save options
case else
end
I really don't know vb just playing with a couple of reports for our local volunteer fire department trying to simplify things.
Thanks for your help
Bookmarks