force save as only if activeworkbook name matches master

**smalltime06** · 02-27-2012, 06:33 PM

Okay, I have

Please Login or Register  to view this content.

Which opens the save as box every time a file is opened. I would like to ONLY open the save as box if the activeworkbook name = "Master". If it is named anything other than "Master" then it would have been saved as before and the save as box should not appear.

I have the Master set as read only under properties when you right click it but I am just looking for another way to help keep it from overwrite. I know little to nothing about vba/excel but would think they could easily right click it themself and take teh read only off just to be a donkey and mess it up without additional protection.

I figure a simple IF / THEN would be used to accomplish the above, but I am a total noob and there is nothing "simple" about this for me, and I have searched for a while with no solution from web that worked for me.

Thanks in Advance!

**davesexcel** · 02-27-2012, 10:32 PM

Possible this would work

Please Login or Register  to view this content.

**smalltime06** · 02-27-2012, 10:39 PM

I was excited for a second.. but I didnt get that to work. It will not bring up the save as no matter what the name is now, Master or other.. Thanks a lot though.

**davesexcel** · 02-27-2012, 10:53 PM

Well it is not supposed to come up if the name is other than "Master"
I guess it should be Master.xlsm

Please Login or Register  to view this content.

**smalltime06** · 02-27-2012, 11:05 PM

BINGO - Thank you a lot. Simple and effective. Thanks!

“Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid.”
― Albert Einstein