|Since we can't see your computer from where we're sitting, we don't know what "excel wouldn't allow me to save the changes" means.|
Did you get an error?
Did you get a message?
Did your computer freeze up?
Maybe just a tad more information might help.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.