Master file has this text "YOU MUST DO "SAVE AS" AND SAVE WITH A NEW NAME" at the top.
When file is saved with a new name, need for that text to disappear.
Thank you
Master file has this text "YOU MUST DO "SAVE AS" AND SAVE WITH A NEW NAME" at the top.
When file is saved with a new name, need for that text to disappear.
Thank you
Hello ILoveStMartin,
We would not know exactly where to start without seeing what your Code or Workbook setup looks like.
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Try this code on the thisworkbook module
It assumes that the text is on Sheet1 Range A1, change to suit your needs
Please Login or Register to view this content.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
Thanks saravnepali,
I was not very clear -
I have the user copy a master and paste it to a customers file and run it from there.
I want the user to be forced to change the name from "Master" and show the customers name.
So the info will not be on the worksheet, only in the file name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks