Hi guys
This is probably going to have a really simple solution that I've entirely failed to notice. However, I have a custom saveas dialog box Module which forces the file to save as .xlsm and gets the file name from certain cells.
I've called that module from an If function which checks the filename first.
Basically, this is me trying to stop the custom save as box from popping up unless it's the original (template) document. I was having problems with subsequent revisions and saves to the resulting file were also popping up the save-as box.
I seem to have fixed that, and it does seem to only be working if the file name matches. However, it then *also* pops up the original save as box, thereby making a user have to save the file twice.
If anyone can help me figure out why the original is still coming up I'd love to know!
The Module is called CPOSave and the code was written by OllieB on this site so I'm familiar with it but don't necessarily fully understand it. Code is:
And the code that calls it is:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks